Hi All,
I confess that I initially tried this on Google Sheets and posted in another thread, but I am going to now recreate this work in Microsoft Excel as it just seems the better option given it appears VBA is the better option - so please ignore the screenshots being GS.
I.e. If I change A9 cell colour to red, can I then have the same value cell in tab "Midfielders" (A15) also change to red automatically?
Effectively, tab "2022 list" is my primary checklist and as I highlight the cells in this list, can the corresponding matching name across tabs 'DEFENDERS', 'MIDFIELDERS', 'RUCKS' and "FORWARDS' mimic the cell colour as I highlight them?
Any assistance will be much appreciated. Thanks.
I confess that I initially tried this on Google Sheets and posted in another thread, but I am going to now recreate this work in Microsoft Excel as it just seems the better option given it appears VBA is the better option - so please ignore the screenshots being GS.
I.e. If I change A9 cell colour to red, can I then have the same value cell in tab "Midfielders" (A15) also change to red automatically?
Effectively, tab "2022 list" is my primary checklist and as I highlight the cells in this list, can the corresponding matching name across tabs 'DEFENDERS', 'MIDFIELDERS', 'RUCKS' and "FORWARDS' mimic the cell colour as I highlight them?
Any assistance will be much appreciated. Thanks.