Copy data validation to new workbook

[AndyFarrell79]

Hi,

Can anyone help? I am trying to replicate a rather large worksheet in a new workbook. I need it to be identical in every way. I have copied the formulae by replacing "=" with "zz" then doing the reverse once pasted into the new book. This way the cells don't refernce the old workbook. However, where I am having trouble is with the data validation. Most have named ranges for the drop lists, however I have some that are just range references.

Is there a way I can go through a similar process to that which I used for the formulae to change my data validation formulae?

Cheers,

Andy

 

[AndyFarrell79]

Have solved this issue.

Please close thread

Thanks