I want to copy a row of cells that contain drop downs to another worksheet.
How do I do this. The copy & paste won't bring it over and the copy & paste
special (either values, formulas or formats) won't do it either.

copy Paste special Validation OK out


"mad227" wrote:

I want to copy a row of cells that contain drop downs to another worksheet.
How do I do this. The copy & paste won't bring it over and the copy & paste
special (either values, formulas or formats) won't do it either.

It does for me. I have 2002. Provide in detail what you are doing. HTH
Otto
"mad227" wrote in message
...
I want to copy a row of cells that contain drop downs to another worksheet.
How do I do this. The copy & paste won't bring it over and the copy &
paste
special (either values, formulas or formats) won't do it either.

Assuming your dropdowns are Data Validation List dropdowns they will copy
over.

But I see a potential problem....

If the list range is a selection of cells like $A$1:$A$10 you will see
nothing in the dropdowns on target sheet.

To work around this, either enter the list as comma-delimited

cat,dog,horse,raven

Or select the list on the source sheet and give it a name like mylist.

In the dropdowns source enter =mylist

When copied to new sheet, they will work.


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 07:59:03 -0700, mad227
wrote:

I want to copy a row of cells that contain drop downs to another worksheet.
How do I do this. The copy & paste won't bring it over and the copy & paste
special (either values, formulas or formats) won't do it either.