Drop-down selection fields

[imported_unknown]

Any help on this would be really appreciated as only a beginner with Excel. (Although a regular observer of this site)

When I copy a sheet from one workbook to another, everything is fine except any drop-down selection fields don't appear, even though the arrow appears whrn the cell is selected. I'm sure there is a simple explanation but as I have hinted, I'm a bit of a prat when it comes to Excel.

Thanks in advance!

Russglos

 

[lenze]

The drop downs receive there information from a list in the workbook. You must also copy that list to the new Workbook and refer to it in the Data Validation dialog box. It sounds like you've copied the validation, but it is reading a blank list. Select the cell and choose Data Validation to see where the list should be located and copy it there from the first workbook

 

[Andrew Poulsom]

It works for me if I copy a sheet rather than a range on a sheet.

In your original worksheet select a cell with the dropdown and choose Data, Validation from the menu.

Look at the Source box. Does it refer to a range outside the area you are copying?

 

[imported_unknown]

Thanks both for your replies - with your diections and a little "winging", Iv'e managed to crack it!!

Bloody Brilliant site Mr. Excel - Keep up the good work!

Russglos