A
Alex Mackenzie
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.
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.