Create a "recap" worksheet that includes all info from all worksh.

T

tdglaw

I need to recap all information from all worksheets on one worksheet. How is
the best way to accomplish this? Is it best to put the info first into the
all-inclusive worksheet and then use a formula on each individual worksheet
to pull certain information?
 
G

Guest

hi,
i think it would be best to put formula on the recap sheet
to pull the needed information from the other sheets.
fomula's like =(sheet2!A1) will return the contents of
cell A1 on sheete2
=sum(sheet2!a1:a10) will sum the range A1:A10 on sheet2
 

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 to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Multiply with Vlookup value from another Worksheet 0
Syncing between source worksheet and dependent worksheets 0
Integrating information from Word to Excel (not mail merge) 1
auto add data with addition of new worksheets 5
how do i lookup and sum from serveral wkshts to a recap sht? 1
Page numbering with Merged Document and IF statements 1
What is the best way to lookup from another worksheet? 0

Top