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

VBA - retrieve data on last create named range from previous inserted named range 0
How do I make worksheet2 = to worksheet1? 2
Pivot Table Data Source 1
consolidate data in pivot table 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
View Pivot Table Source data as a Data Table 6
Pivot Table counting a range 1
Please Help with Two Table Merging 1

Top