can I carry forward formula to next page of workbook?

[davidsdottir]

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

 

[Fred Smith]

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

Where July is the name of July's sheet.

Regards,
Fred.

 

[davidsdottir]

Thank you, that works great!
D

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

Where July is the name of July's sheet.

Regards,
Fred.