Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Lists/Summary Page
,Hello,
I have a workbook with multiple sheets. Each sheet has 4 columns and depending on the amount of data, multiple rows (usually between 1 and 20). I would like to create a summary page that would search all of the worksheets for data entered and combine all of these rows of data (no need to search for duplicates - there won't be any) on one main sheet. Is this possible? It seems like an array formula may do the trick but I'm not too deft at writing my own arrays. Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple lists into one ! | Excel Worksheet Functions | |||
combining two lists | Excel Worksheet Functions | |||
Combining 2 lists | New Users to Excel | |||
Q: how to create summary daily lists from another, and reverse | Excel Worksheet Functions | |||
combining excel lists | Excel Discussion (Misc queries) |