OK - looking again at your requirements, I'm not sure this can be done quite as you wish without VBA.
You might want to start here and read up on data models and see if it will get you anywhere close to what you want: https://support.office.com/en-us/art...0-5c75dbcb0f7b
Maybe someone else here who is more familiar with data models can advise a little more.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Okay! Thank you for the help anyway!
To me this doesn't seem that hard to accomplish, cause it seems like all you have to do is connect the filters on the ID columns in the different worksheets, so that when you change one, all the worksheets should filter.
If any1 else can help solve this problem without VBA please let me know! because I know it can be done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bwizzleman 
Register To Reply
Bookmarks