hapless in seattle
New Member
- Joined
- May 19, 2005
- Messages
- 2
Greetings --
I need to make an Excel file that contains multiple instances of the same data entry form within a single worksheet. The form contains some option buttons. I've made a single instance of the form, with the option buttons linked to cells as I want them to be. But, when I copy and paste the form, the option buttons in the new (pasted) form remain linked to the cells in the old (copied) form, instead of "updating" to new cell references.
I can manually assign cell links for each instance of the form within the worksheet, but is there a faster way? Is there a way to copy and paste my form so that each new instance will have its option buttons linked to new corresponding cells, like the way it does when copying & pasting formulas?
THANKS in advance for any help.
I need to make an Excel file that contains multiple instances of the same data entry form within a single worksheet. The form contains some option buttons. I've made a single instance of the form, with the option buttons linked to cells as I want them to be. But, when I copy and paste the form, the option buttons in the new (pasted) form remain linked to the cells in the old (copied) form, instead of "updating" to new cell references.
I can manually assign cell links for each instance of the form within the worksheet, but is there a faster way? Is there a way to copy and paste my form so that each new instance will have its option buttons linked to new corresponding cells, like the way it does when copying & pasting formulas?
THANKS in advance for any help.