Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Roll-up data into master report
I need to roll-up data from three different people into a single
spreadsheet. This "master" spreadsheet must have the ability to be sorted (currently using autofilter). Help appreciated. |
#2
|
|||
|
|||
Roll-up data into master report
Without any details on your data layout, it's hard to offer advice. If
each person's data is in a table, you could copy and paste so it's all in one table. If necessary, add a new column that contains the person's name, so you can identify the data later. Then, select the entire table, and apply the AutoFilter. Ron de Bruin has sample code for combining worksheets: http://www.rondebruin.nl/copy2.htm Annabelle wrote: I need to roll-up data from three different people into a single spreadsheet. This "master" spreadsheet must have the ability to be sorted (currently using autofilter). Help appreciated. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Roll-up data into master report
I think this will get me where I need to be. Thank you for your help.
Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Sorting data in a master sheet | Excel Worksheet Functions | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
print report with data from specific worksheet | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |