Move data from one worksheet to another.

  • Thread starter Thread starter JCreationBoy
  • Start date Start date
J

JCreationBoy

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.
 
You can use cell references. For example...

=Sheet1!A1

then you can drag it down / across as per the need.
 
Back
Top