Hello,
Is there a way to link cells from different sheets?
I have a drop down data of dates and I want it so that if I filter a specific date, then all the dates from each sheet will be the same as the one one the first sheet.
Thanks,
l Flipboi l
Hello,
Is there a way to link cells from different sheets?
I have a drop down data of dates and I want it so that if I filter a specific date, then all the dates from each sheet will be the same as the one one the first sheet.
Thanks,
l Flipboi l
Show us what you mean with a sample workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
I've attached a sample book,
If Sheet 1 filters a "1" then I would like sheet 2 and 3 to display "1" as well.
is my sample book sufficient?
Probably is. But your use of Excel's List feature on all the sheets flummoxed my efforts. Normal data set ranges I can do, but I couldn't figure out the filtering in the LIST ranges. Sorry.
Np, thanks for trying!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks