How do I copy a sheet in Excel that includes drop downs, and past the whole sheet into a new workbook without losing the drop downs?

If you use the "Worksheet Copy" method, then the DropDowns that have the lists hard coded should be copied with the sheet.

Guidelines to copy a worksheet to another workbook.

1. Open the destination workbook (In addition to the workbook containing the sheet to be copied).
2. Select the workbook containing the sheet to be copied.
3. Right click on the worksheet tab name of the sheet to be copied.
4. Select Move or copy in the dialog.
5. Click the DropDown arrow at the end of the To book: field.
6. Select the destination workbook from the displayed list.
7. Select the preferred location in the destination workbook from the displayed list. (eg. before a specific sheet or move to end).
8. Check the “Create copy” field towards bottom of the dialog. (Ensure you do this, or it will delete the sheet from the source workbook).
9. Click OK.
10. The worksheet should now be copied to the destination workbook and the Validation DropDowns should work.

@OssieMac , The Validation DropDowns do not work when using your method.

Then the validation drop downs are depending on values of cells on another worksheet. You'd have to copy that worksheet, too, and then reset data validation to the same range as before.

Hi,

I am not very technical on Excel so apologies if I am confusing things.

I dont think there is a source for the drop downs. I think the person who created the sheet just created 3 options for the column. Basically, 'Low, Medium or High'. So within each row under that column you have to select either option.

Would a data source have been required for that?

Thanks

I am assuming that your method of Copy the worksheet is to right click the tab name and select Move or Copy. If so, for the dropdowns to continue working, the source for the DropDown list needs to be on the same sheet.

If you cut and paste the list from another worksheet to a spare area on the sheet to be copied, then the dropdowns will inherit the list that has been cut and pasted and because it is now on the same sheet, all the DropDowns should copy with the worksheet copy.