Hi,
I have a worksheet containing a with dropdown menus in some columns which I set up using the data validation tab. When I copy and paste the table to a different sheet, the dropdown menu seems to be unable to find the original source columns for the dropdown options. Is there a way copy and paste the table and retain the dropdown menus?
Thanks in advance.
I have a worksheet containing a with dropdown menus in some columns which I set up using the data validation tab. When I copy and paste the table to a different sheet, the dropdown menu seems to be unable to find the original source columns for the dropdown options. Is there a way copy and paste the table and retain the dropdown menus?
Thanks in advance.