Merge data from several worksheets to create one

D

Dyanna

I have several worksheets which show profits from different jobs - I want to
create a "master" worksheet that will "draw" the totals from each of these
worksheets? I was told to try Access 2003? I'm note sure it can be done.
 
B

Bob I

In the master sheet, you may have a cell reference a cell in another sheet.

In the master, click the cell, put in an equal sign and then select the
cell in the sheet that has the "total" you want to include.
 
Top