D Dave Peterson Jul 13, 2007 #2 I think you'll have to reassign the cell link after you do your copy|Paste. Alternatively, you could use a macro to create the dropdowns where you need them and assign the linkedcell to whatever you want.
I think you'll have to reassign the cell link after you do your copy|Paste. Alternatively, you could use a macro to create the dropdowns where you need them and assign the linkedcell to whatever you want.