Goal: Copy unknown # of sheets in a workbook that cell formulas references the previously copied sheet.
NOTE: I need to Lock the sheets and protect the workbook, but cannot get it working protected or not.
I have a master sheet in a workbook "PR1" that I have filled out, I also have "PR2" that has formulas that references "PR1". "=('PR1'!A2+1)"
Issue: I might need "PR2" or might need to go all the way up to "PR20", when I simple copy "PR2" to "PR3", formulas still reference "PR1" when I need them to reference "PR2" that was copied.
Issue: If I copy "PR2" and go to edit the formulas in the new "PR3", whether I do it in the formula bar or using the "Find & Replace" command, I would expect any references to change but instead the "Windows File Explorer" opens.
Example: In "PR2" I have "=('PR1'!A2+1)", I want this to be "=('PR2'!A2+1)", and so on.
NOTE: I need to Lock the sheets and protect the workbook, but cannot get it working protected or not.
I have a master sheet in a workbook "PR1" that I have filled out, I also have "PR2" that has formulas that references "PR1". "=('PR1'!A2+1)"
Issue: I might need "PR2" or might need to go all the way up to "PR20", when I simple copy "PR2" to "PR3", formulas still reference "PR1" when I need them to reference "PR2" that was copied.
Issue: If I copy "PR2" and go to edit the formulas in the new "PR3", whether I do it in the formula bar or using the "Find & Replace" command, I would expect any references to change but instead the "Windows File Explorer" opens.
Example: In "PR2" I have "=('PR1'!A2+1)", I want this to be "=('PR2'!A2+1)", and so on.
