sorting data from one table/range to another table/range

D

Danko Jotanovic

I am having a worksheet with a range of data sorted in i.e. 6 columns.
The first column is populated with entries consisted of 10 different person
names (i.e. John, Mary,…, Paul) in random order.

What I need is to create tables in separate worksheets (named with
corresponding person) that sort data for each person name from worksheet1

Those tables should maintain the same format as the source table in
worksheet1 and they should be automatically updated when new entry is added
to the source table.

Example:
All rows that contain person name John in the source table should be listed
in separate table in worksheet “Johnâ€. When new entries are added to the
source table in worksheet1, only rows that contain person name John should be
automatically added to the table in worksheet “Johnâ€
The same should aplied for other person names as well
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Format column widths from one table to a separate table on same page 1
Extract data in rows (with line breaks) to form a table 0
Construct table from selected rows 4
Excel 2007 pivot table using analysis services cube as data source 0
Macro to update pivot table data range 3
How do I make worksheet2 = to worksheet1? 2
Help with finding result from data 0

Top