Hi,
I have a master workbook and I have data validation.
After I copied some sheets and paste these in Master, the data validation dropdown lists are gone.
I can't see those.
How can I see that again in Master workbook?
Thanks
Hi,
I have a master workbook and I have data validation.
After I copied some sheets and paste these in Master, the data validation dropdown lists are gone.
I can't see those.
How can I see that again in Master workbook?
Thanks
When you paste over a cell with validation, it will take the new formatting.
To avoid this you have to use the Paste->Values option. This will not modify the existing formatting.
Thanks!
You mean pasteSpecial?
Yes, use Paste Special
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks