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.
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.
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
I think this will get me where I need to be. Thank you for your help.
Ann
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks