Duplicate linked Tables
I have a table1 in Sheet 2 which is feeding multiple pivot tables on Sheet 1 (Executive Summary) and has formulas and a lot of conditional formatting. I need this table1 duplicated and linked in Sheet 3 so I may use the subtotal values from the table based on color filters. I cant do that using table1 in Sheet 2 as changing filters would change the subtotal value. So i'll dedicate Sheet 3 for a particular subtotal after using "color filter" feature of the table and hide the sheet so the filters are not changed.
So basically what I want is that whatever updates I make in Sheet 2 (table1) gets automatically updated in Sheet 3 (table1 duplicate)
I am using Excel 2010.
Any help would be much appreciated.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1