Duplicating a table to sort/filter data different ways

JStirfry

New Member
Joined
Nov 12, 2018
Messages
25
Hello. I'm looking for a way to duplicate a 'master' Excel table so I can have the exact same table copied multiple times, side-by-side, but with each table sorted and/or filtered slightly differently. The idea is that only the 'master' table be edited and the other tables feed off of it and update automatically.

Any help is greatly appreciated!
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
copy the table to 10 more sheets then use a pivot table on each sheet - should you amend the master then copying it again would take seconds...........
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,307
Members
409,862
Latest member
lbisacca
Top