Updating formulas between workbooks

[Guest]

Hi.

I have a series of monthly workbooks, each of which contains 11 sheets plus
a summary sheet. The summary is a simple addition of ten of the sheets
(=1+2+3).

When I copy the workbook to create a new month, the summary sheet refers
back to the one I copied. (=[oldmonth1]+[oldmonth2]+[oldmonth3].

How can I get the summary to relate to the new month without redoing 10
pages, each of which contains 16 lines needing update? I'm in Excel 2007.

 

[John W. Vinson]

Hi.

I have a series of monthly workbooks, each of which contains 11 sheets plus
a summary sheet. The summary is a simple addition of ten of the sheets
(=1+2+3).

When I copy the workbook to create a new month, the summary sheet refers
back to the one I copied. (=[oldmonth1]+[oldmonth2]+[oldmonth3].

How can I get the summary to relate to the new month without redoing 10
pages, each of which contains 16 lines needing update? I'm in Excel 2007.

The Microsoft webpage has misled you - this newsgroup is for Microsoft Access,
not for Excel. Please scroll down the list of subject areas and post a fuller
description of your spreadsheet in an Excel newsgroup.

John W. Vinson [MVP]