Is there a way to have two identical lists on seperate worksheets and by filtering the list on 'Sheet 1' for it to automatically filter the list in the same way on 'Sheet 2'?
Is there a way to have two identical lists on seperate worksheets and by filtering the list on 'Sheet 1' for it to automatically filter the list in the same way on 'Sheet 2'?
That would require installation of active "event" macros into your workbook. If you're OK having macros active in your workbooks, upload a sample of your workbook and I can show you how it would work, basically. You'll have to get up to speed on using macros and getting comfortable with that from there.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks