Move data from one worksheet to another.

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.
 
G

Gaurav

You can use cell references. For example...

=Sheet1!A1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bugs in Office 2019 0
External cell reference between two excel worksheets both in One Drive 0
formula issues. 0
Help with a running total on multiple sheets 2
How To Rapidly Copy Formulas? 0
Lookup whole sheet and add datas from specified date to end date 0
Embed the same Excel multiple times 0
Add total items in from another worksheet? 0

Top