Copy and Paste solution needed

Hi,

I have a user form with a month Dropbox. What I need is... that when I change the data in sheet one it copies the sum total at the bottom and pastes it over to the cover sheet in the corresponding month. There are up too 10 sheets used in this work book and I need them all too do the same.

Example:
Set the user form to February press ok.
Then change the cells of data in sheets 2-11
The total changes at the bottom of the sheet.
Do the same for all the over sheets.
The total at the bottom is automatically copied and pasted to the selected month in sheet 1 set on the user form.
Then when I launch the workbook again and select march & press ok then the changed total on sheets 2-11, the total at the bottom is then copied and pasted onto march and so on.

Any one got any idea???

It would be a great help.

Nick

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

You do not need to upload sensitive file. Dummy data will do. As long as the format matches the original, we are fine.