May 03 2022 05:46 PM
I have two workbooks that have a similar structure but different contents:
Workbook 1:
Workbook 2:
The issue I am seeing occasionally is when I move the "results" worksheet to workbook 2 and click yes to the name conflicts, the row number that the "profit" named range is scoped to changes to row 368 in workbook 2. That is the scope for "profit" in workbook 1, why is it changing in workbook 2? Unfortunately this only happens occasionally when repeating the same steps.