Hey all

I got 2 workbooks. Each has an identicle sheet titled "Lookup" which lists all lookup tables. These are listed as named ranges and used in data validation within numerous other sheets. I need to copy some sheets across and want it to reference the "Lookup" sheet from the new workbook, not reference back to the original workbook. I don't want links through as file names get changed a lot.
Is that possible without re-entering all validation on every copied sheet??

I say yes to when it says there is a conflict and if I want to use the destination named range. It still makes duplicate references to the other workbook.
I also tried deleting the duplicate so there is only a single named range with the same name but the data validation refuses to use that named range even though there is no reference to the other workbook. For example, there is a named range called "Weight" and there is a data validation that points to "=Weight", but I get an error saying that it does not exist.

What am I doing wrong?

Thank you
Alan