| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move data from one worksheet to another.
My thing is I have lets say 5 worksheets all under one file name. Each sheet
contains money totals for one particular area. I then have another sheet that contains all of the totals from the other four sheets and the overall total. What I have been doing is taking each total from each sheet and copying and pasting. Is there a formula that you can use to do that automatically? I am useing Excell 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move data from one worksheet to another.
You can use cell references. For example...
=Sheet1!A1 then you can drag it down / across as per the need. "JCreationBoy" wrote in message ... My thing is I have lets say 5 worksheets all under one file name. Each sheet contains money totals for one particular area. I then have another sheet that contains all of the totals from the other four sheets and the overall total. What I have been doing is taking each total from each sheet and copying and pasting. Is there a formula that you can use to do that automatically? I am useing Excell 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move Specific Data to Another Worksheet | Excel Worksheet Functions | |||
| How do I move data from one worksheet to another? | Excel Discussion (Misc queries) | |||
| How do I move certain Cell data from one worksheet to another? | Excel Worksheet Functions | |||
| Move select data to another worksheet | Excel Discussion (Misc queries) | |||
| How to move data on worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
