excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have two workbooks, workbook one and workbook two. I converted all the data validation drop down lists in workbook one, of which there were many, to pull from tables rather than data ranges, so more can be added or modified easily. The lists of options for all the data validation lists are exactly the same, just converting from "=$G$9:$G$12" to "=INDIRECT("Status[Status]")" for example.
Now I want to copy the data from workbook two with the ranges into workbook one with the tables. How do I do that and not have it copy the data validation ranges too? I tried to remove the data validation from workbook two before I copied and pasted it, but then it removes the data validation from workbook one.
Is there a way to do this?
Now I want to copy the data from workbook two with the ranges into workbook one with the tables. How do I do that and not have it copy the data validation ranges too? I tried to remove the data validation from workbook two before I copied and pasted it, but then it removes the data validation from workbook one.
Is there a way to do this?