Dear all,
Before I start trying to reinvent the wheel.
within my code I am creating a workbook of worksheets pulled from other workbooks. The problem is that I have one worksheet which has formulas in it that I want to use in the new workbook to pull data.
original formula
when the worksheet in moved into the new workbook
is there a way in VBA or excel in general when moving the sheet into the new workbook to stop the formula being update and reference the sheet named 'Total to be invested' in the new workbook rather than the original sheet
thanks in advance
Before I start trying to reinvent the wheel.
within my code I am creating a workbook of worksheets pulled from other workbooks. The problem is that I have one worksheet which has formulas in it that I want to use in the new workbook to pull data.
original formula
Code:
=IFERROR(ROUNDDOWN('Total to be invested'!$H4*(INDIRECT("'"&C$1&"'!O10")/'Total to be invested'!$E4),0),"")
when the worksheet in moved into the new workbook
Code:
=IFERROR(ROUNDDOWN('[Template Sheet.xlsm]Total to be invested'!$H4*(INDIRECT("'"&C$1&"'!O10")/'[Template Sheet.xlsm]Total to be invested'!$E4),0),"")
is there a way in VBA or excel in general when moving the sheet into the new workbook to stop the formula being update and reference the sheet named 'Total to be invested' in the new workbook rather than the original sheet
thanks in advance