Posted 01 May 2007 - 09:48 AM
Can anybody tell me how to archive data or text from one worksheet to another.
I have a so called calculator that works out how much money i will need to do .
Then on another sheet i input manually the amount of money and where it is going, date etc etc
Instead of doing both processes i would like the spreadsheet set up and i just enter all details in the calculation part, then to click a button and the whole lot transfers over neatly into the spreadsheet.
Hope this makes sense.