I have a table of numbers with spinbutton controls where the linked cells are in C104:F117.
Depending on the value of another cell, I need to be able to switch those linked cells to a different range, eg G104:J117.
I can't seem to use the "indirect" function in the linked cell reference though, as "tried" in the attached image. Is there another way?
Capture.JPG.
Any ideas how to achieve this?
Bookmarks