| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula from 1 workbook to another & not carry the extension | Excel Worksheet Functions | |||
| linking cells to carry forward a hyperlink | Setting up and Configuration of Excel | |||
| Create 52 sheets and carry all formulas and figures forward? | Excel Worksheet Functions | |||
| How do I insert a line in excel and carry the formula forward? | Excel Discussion (Misc queries) | |||
| Carry forward formula help needed | Excel Discussion (Misc queries) | |||
Linear Mode
