Drop-down selection fields

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Active Member
Joined
Jan 13, 2002
Messages
424
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
 

Forum statistics

Threads
1,143,614
Messages
5,719,719
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top