If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can collect data from multiple sheets in the same workbook?
Hello, I am trying to collect data from multiple sheet in a workbook. I want
to summarize the data on a seperate for printing. |
#2
|
|||
|
|||
How can collect data from multiple sheets in the same workbook?
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. "rrok" wrote: Hello, I am trying to collect data from multiple sheet in a workbook. I want to summarize the data on a seperate for printing. |
Thread Tools | |
Display Modes | |
|
|