|
|
|
|
#1
03-08-2016, 02:37 PM
|
|||
|
|||
How about just keeping one sheet and applying filters there? Why do you need duplicate data? It's not advisable.
Otherwise, if you simply must have separate tables, you could insert pivot tables on the other sheets. Unfortunately, if the data change on the master sheet, you will have to manually refresh the pivot tables. A sample sheet would be more helpful than this... Quote:
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trying to find a macro that will copy a cell and paste that value to a specific sheet | bryans88 | Excel Programming | 1 | 12-23-2015 01:40 PM |
| Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
 Help Coloring a cell in Sheet one if data is missing from another sheet
|
Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
| Data dependant on checkboxes? | ryanf | Word | 2 | 11-01-2012 05:00 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode