Data Validation question.

[MarkOW]

Hi,

I have a workbook 'workbook A' which contains the worksheet 'Datasheet'.
Datasheet contains all data validation drop-down lists in this workbook.

I would like to replace 'Datasheet' with a sheet from another workbook - 'workbook B' - also named 'Datasheet'.

Is it possible to do this without losing all validation links from 'workbook A'

Thanks

Mark

 

[MarkOW]

Ok thanks for looking.

I just realized all I need to do is copy the sheet info over & not the full sheet. Doh!

Thanks