Creating External Reference from 'Data Reference' Worksheet

[cristopulo]

Hello,

I am trying to create an external reference linked to a DataSheet in another workbook.

Basically I have all my information and data in 2 worksheets based on a 'Data Reference' worksheet in the same workbook. This contains simply everything from named ranges used for Data Validation to INDEX / MATCH table sources. The actual Output worksheets use Macros as well as Data Validation and Index/ Match but are all linked to tables in this worksheet.

I wanted to be able to copy all this data into another workbook and keep this as the reference in the company database so that anyone can update it. This would hereby change the information in the original worksheet that is intended to be sent out to clients.

I thought of copying everything in the Data reference worksheet and then using the paste special and pasting it as a link in another workbook. This would then change the original Data reference and I would be able to hide the page and lock the workbook to keep clients from viewing or accidentally tampering with it.

This did not work and I have not been able to manage how to use a new source workbook to solve the issue.

Would I have to copy everything in the 'Data Reference' worksheet into another workbook and delete the original reference. Then Open a source workbook where all my original Data is linked. The point is just to be able to update the worksheets data after it has already been sent out to clients and users.

Thank You very much in Advance and please let me know if I haven't explained something correctly!