can I carry forward formula to next page of workbook?
 

doing accounts - sheet of workbook per month - is it possible to carry
forward total from each page to next as a formula, then include it in total
for that page, and so on? eg cell J2 for Aug should = cell J33 for July

can I carry forward formula to next page of workbook?
 

In J2 of Aug, you put something like:
=July!J33

Where July is the name of July's sheet.

Regards,
Fred.

"davidsdottir" wrote in message
...
doing accounts - sheet of workbook per month - is it possible to carry
forward total from each page to next as a formula, then include it in
total
for that page, and so on? eg cell J2 for Aug should = cell J33 for July

can I carry forward formula to next page of workbook?
 

Thank you, that works great!
D

"Fred Smith" wrote:

In J2 of Aug, you put something like:
=July!J33

Where July is the name of July's sheet.

Regards,
Fred.

"davidsdottir" wrote in message
...
doing accounts - sheet of workbook per month - is it possible to carry
forward total from each page to next as a formula, then include it in
total
for that page, and so on? eg cell J2 for Aug should = cell J33 for July