Hello,
I have a workbook that is collecting information from many other workbooks. An example formula that I am using is:
='[01.xlsx]Cover Sheet'!$E$23<strike></strike>
The row where this formula is located would be collecting several cells from this same workbook.
The next row would collect the same data, but from a different workbook (02.xlsx) located in the same directory.
Is there a way to make this change across all of the columns without having to replace the "01" with "02" in each cell?
Thanks,
Mark
I have a workbook that is collecting information from many other workbooks. An example formula that I am using is:
='[01.xlsx]Cover Sheet'!$E$23<strike></strike>
The row where this formula is located would be collecting several cells from this same workbook.
The next row would collect the same data, but from a different workbook (02.xlsx) located in the same directory.
Is there a way to make this change across all of the columns without having to replace the "01" with "02" in each cell?
Thanks,
Mark