Mass changes to Names

[laya1024]

Hi All-

I have a workbook that has 100+ names in the name manager. The formula is essentially all the same formula. It is an offset that references different cells. I have to change the formula. Is there a way to do a mass change instead of one by one? The beginning part of the formula remains the same, something towards the end of it is changing. I have several workbooks with the same issue.

[mdbct]

The following would shift the last cell referenced down 1 row. For exapmle your current reference is=Sheet1!A1:A4, the new reference is =Sheet1!A1:A5

Please Login or Register  to view this content.