data validation-list is not transferred over the the new Workbook

**cercig** · 04-21-2021, 11:52 AM

Hello,

I have a data validation list in my main workbook "Main_table.xlsm" under 3 different sheets "Customer", "Product" and "Geography".
This data validation list is using the list in the sheet "lookup".

My VBA-code is creating 3 different new Excel-files for "Customer", "Product" and "Geography", and it also copies the sheet "lookup" to all new Excel-files to be able to retain the dropdowm list/data validation.

However, the dropdown/data validation list disappears in the output files under the Column-B.

Do you have any suggestion?

Thanks in advance...

Please Login or Register  to view this content.

**cercig** · 04-21-2021, 04:16 PM

Hi,

I solved this by myself by recreating the data validation list as below:

Please Login or Register  to view this content.

**nankw83** · 04-22-2021, 11:17 AM

Hi cercig,

This is another method which is a bit simpler ...

Please Login or Register  to view this content.

data validation-list is not transferred over the the new Workbook

LinkBack

Thread Tools

Rate This Thread

Display

data validation-list is not transferred over the the new Workbook

Re: data validation-list is not transferred over the the new Workbook

Re: data validation-list is not transferred over the the new Workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Put a date in column B when data was transferred to another workbook

[SOLVED] Transferred data overwriting previous transferred data

Data Validation List from another Workbook

data validation list in external workbook

Different workbook data validation which updates list

Data Validation - using a list from another workbook

Using Validation List from Another Workbook with Dependent Data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions