How can collect data from multiple sheets in the same workbook?

R

rrok

Hello, I am trying to collect data from multiple sheet in a workbook. I want
to summarize the data on a seperate for printing.
 
J

JLatham

Without more details ragarding the information, you should start looking into
worksheet functions:
VLOOKUP() [or possibly even HLOOKUP()]
SUMIF()
and if data is to be gathered based on multiple criteria on a single row on
any given sheet, then SUMPRODUCT() [for pre-2007 Excel] or SUMIFS() [Excel
2007 unique].

You may have to build up formulas that the summary results from one sheet to
that of others.

Might even search Excel Help for the phrase
Refer to the same cell or range on multiple sheets
which may lead to information you can use.
 

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

Excel data collection 2
Collect data from spesific cell in multiple sheets 4
Merge Multiple workbook sheets into one workbook 0
concatenate with more than 10 sheets 2
Excel shortcut options 0
Custom Reporting Across Sheets 1
advise on how to import data into excel sheet 1
... I want to chart data from 30 separate worksheets ... 1

Top