Use same stepper/dropdown on 2 different sheets, but for same purpose.
I have a "Stepper" (to increment year) which is referenced by a chart for calculation.
I want to use a copy of that same "Stepper" (for that same purpose) and put it on another sheet.
So, if I choose "2023" on the stepper on page one, i want the stepper on page two to show same value (2023)...and vise versa. I want to select the year on either page that will still work for the same chart calculation.
Is this possible?
PXC
MacBook Pro 15″, macOS 10.15