Mattywerts
asked on
Excel formula to reference Active worksheet.
Hi experts,
I am attempting to copy a formula from one work book to another. Both are based on the same template, i.e cell layout, worksheet tabs etc.
I noticed that in the formula I am attempting to copy from there is a reference to the workbook i.e ([workbook1.xlxs). When attempting to copy to the new workbook it still references the original workbook I have copied from. I may be way off the beaten track on this one but is there anyway I can copy the formula and make it reference the active workbook?
I am attempting to copy a formula from one work book to another. Both are based on the same template, i.e cell layout, worksheet tabs etc.
I noticed that in the formula I am attempting to copy from there is a reference to the workbook i.e ([workbook1.xlxs). When attempting to copy to the new workbook it still references the original workbook I have copied from. I may be way off the beaten track on this one but is there anyway I can copy the formula and make it reference the active workbook?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help.
Dave