![]() |
Losing reference when deleting worksheet
I have a workbook with multiple worksheets. One of the worksheets contains
data that is used in formulas in the other worksheets. The workbook is distributed to other people for them to use. When I need to update the data with new values, I would like to be able to just send around the worksheet for people to add to the workbook. But if they delete the old data worksheet, the formulas all lose the link to the data. Is there a way I can reference the data worksheet so that I can replace the old data worksheet with the new data worksheet. There is a lot of data involved, so just cut and paste into the workbook is not the preferred option. Thank you. |
All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com