Forum Discussion
Formulas that carry from one workbook to another
I have multiple formulas like the following [=SUM(LTBHS!S6)] that refer to a sheet (entitled LTBHS) in the current workbook. I need to copy these formula to other workbooks but always want to refer ...
Thank you but since I have several of these formulas, I was hoping there would be some way to automate the process so I won't have to copy or re-create the formula.
You could copy a range from one workbook to a range in exactly the same position in the other workbook.
The formulas will look like =SUM([FirstWorkbook.xlsx]LTBHS!S6)
Use the Replace dialog (Ctrl+H) to replace [FirstWorkbook.xlsx] with nothing.