I am using a spreadsheet created by someone else some time ago. It contains
drop down boxes. I'm not familiar with forms and drop down boxes, etc. When
I right click on each drop down, and click Format Control, I want to revise
the Cell Link to be the row I'm on, but I also want to update the Input Range
to be a different sheet within the same workbook. Does this make sense?? If
I try to copy the box with the Drop Down by arrowing over onto that cell, and
doing Ctrl+C, then moving to the destination and doing Ctrl+V, it just copies
the same Cell Link and Input Range. The only way I can see to change either
or both of these is to right click every Drop Down box, choose Format Control
and change each one manually. I have 60 rows and 17 columns, this could take
hours!! HELP.