BleepingComputer.com: Excel - Archiving Text To Another Worksheet

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.

Thanks

Hi there,

First, you will need to define - clearly - where your data will be going from and where it will be going to. That's pretty much it. You've already told us you want to trigger it with a button, the rest is fairly straightfarward (with that info).

I don't understand why the "calculator" would have to be on a separate worksheet. Is the object to budget a calculated income?
Regards,
John