K
kjh4eyes
I have two workbooks, call them Workbook A and Workbook B. Workbook A is a
template that I use to track monthly sales, cash flow, etc. Each month I
simply plug in the new dates on each worksheet. Worksheet B is the current
month's report. I added a page with new formulas to the template (Workbook
A). I now want to transfer that page to Workbook B. When I copy and paste the
page from Workbook A to Workbook B all of the formulas refer to worksheets in
Workbook B. I want to make those formulas refer to the worksheets in Workbook
A so I don't have to go back in and reenter data. I know there must be a way
to do this but I do not know what it is. Can someone out there help this
Excel novice?
template that I use to track monthly sales, cash flow, etc. Each month I
simply plug in the new dates on each worksheet. Worksheet B is the current
month's report. I added a page with new formulas to the template (Workbook
A). I now want to transfer that page to Workbook B. When I copy and paste the
page from Workbook A to Workbook B all of the formulas refer to worksheets in
Workbook B. I want to make those formulas refer to the worksheets in Workbook
A so I don't have to go back in and reenter data. I know there must be a way
to do this but I do not know what it is. Can someone out there help this
Excel novice?