Hi all,

I have created a workbook to help track our suite of applications which was working fine until I shared it out. I have since found out that you are not able to copy/past Data Validation in a shared workbook.

The purpose of the workbook was to allow applications to be assigned to an Analyst to work on and re-assign as required. An Analyst could choose their name from the Data Validation List and it would move the row of associated data to a tab with the corresponding name (choose the name Jim from the DVL in cell H2 on the unassigned tab and the macro moves the contents of row 2 to the tab called Jim). The problem occurs when reassigning as the DV is not copied (the macro still works if the Analyst types in a new name to assign it to).

Any ideas how I can get around this?

Thanks