Simultaneously updated cells
Gonna try my best to explain the problem here. It's a simple one but has got me incredibly stuck. I have two sheets in excel that are titled with months in the calendar year. I want it to be so when I change months in the first sheet it also changes it in the second and vice versa. I heard excel active x comboboxes are the way to go for this but I don't really get how it works.
If someone could explain them or just make the combobox in excel that would be greatly appreciated. Thanks!
Welcome to the forum.
Administrative Note
Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. In Excel, go to File | Account and read what it says at the top - add this information to your profile. Thanks.Don't know
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You probably need to use worksheet Change Event handlers on each worksheet to update its opposite number.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe this will help?
https://www.excelforum.com/excel-pro...duplicate.html
So if your months were in cells A1: L1 in both worksheets called "Sheet1" and "Sheet2", you could repurpose the previous link as follows
In a module:
In Sheet1's Change event:
Please Login or Register to view this content.
In Sheet2's Change event:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks