create a summary sheet with totals from many worksheets

P

PiloErector

I have worksheets in an excel file.
I would like to encapsulize the totals on a single sheet
with links from the worksheets on the summary sheets.

How can I do this?????????????
Please contact directly and mark subject box excel summary
so I will open and not treat as junk..........
 
D

Diana

Enter a plus sign in the cell on the summary sheet and
then click the sheet tab of the work sheet you need to
pull from, then go to the cell within that sheet that has
the total. The link will be created automatically for
you.
 

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

How do you make a summary sheet? 0
Update several ppt documents from a single excel file 0
summaries on alternative sheets 6
summary values across worksheets within the same workbook 2
Spreadsheet summary automatically referrences totals of worksheets 2
Summary 2
Totalling data from several workbooks to a Summary Sheet 1
Highlighting multiple triggers 4

Top