Moving cell w/ drop down list to a new sheet

[echous]

I've got almost one hundred cells with existing drop down lists. I need to cut each cell and move it to another sheet without having to redefine the link to the list data. How can I do that?

 

[Smitty]

Welcome to the Board!

Cut/Paste will retain the list link.

But it would probably be easier to just copy the sheet.

Or if you can define the source & destination ranges someone can probably come up with some code to do it.

HTH,

 

[echous]

A standard cut/paste is copying whatever field is already selected from the drop down list in the source cell to the destination cell. The destination cell also has a drop down, but it is empty of the selections that were in the source cell.

Can't just copy the entire sheet. Goal is to take a complex engineering sheet with many drop down lists scattered throughout and create a simpler form that would drive the complex existing sheet.

That's why we want to move the existing drop downs to the new sheet without having to redefine where the list is and what cells are included in it.