Repeat formula on each page

[meznak]

I have a multi-page spreadsheet with repeated rows at the top. In one
of the repeated cells (or the header), I would like to have a formula
generate an output.

Example:
1 Page Title | North01.05
2 Room | Row | Cabinet | More Data
3 North | 01 | 05 | Blah
--------------------------
Page Title | South02.08
Room | Row | Cabinet | More Data
4 South | 02 | 08 | Blah
--------------------------

I am able to get the concatenation to work fine for the first sheet
(=[A3] & [B3] & "." & [C3]), but it just repeats that value
(North01.05) on each page. How can I make Excel reevaluate this
formula for each page (i.e. =[A4] & [B4] & "." & [C4] for page 2)?

 

[Guest]

Print each page individually. Adjust the formula before printing.

 

[meznak]

As I'm looking at several hundred cabinets, that is not an option.
Any other ideas?

Print each page individually. Adjust the formula before printing.

--
Regards,
Tom Ogilvy

I have a multi-page spreadsheet with repeated rows at the top. In one
of the repeated cells (or the header), I would like to have a formula
generate an output.

Example:
1 Page Title | North01.05
2 Room | Row | Cabinet | More Data
3 North | 01 | 05 | Blah
--------------------------
Page Title | South02.08
Room | Row | Cabinet | More Data
4 South | 02 | 08 | Blah
--------------------------

I am able to get the concatenation to work fine for the first sheet
(=[A3] & [B3] & "." & [C3]), but it just repeats that value
(North01.05) on each page. How can I make Excel reevaluate this
formula for each page (i.e. =[A4] & [B4] & "." & [C4] for page 2)?

 

[Mark Lincoln]

I think you'll have to find a way to put the page titles at the top of
the individual pages so that they print just below the repeated rows.

Mark Lincoln

As I'm looking at several hundred cabinets, that is not an option.
Any other ideas?

Print each page individually. Adjust the formula before printing.

I have a multi-page spreadsheet with repeated rows at the top. In one
of the repeated cells (or the header), I would like to have a formula
generate an output.
Example:
1 Page Title | North01.05
2 Room | Row | Cabinet | More Data
3 North | 01 | 05 | Blah
--------------------------
Page Title | South02.08
Room | Row | Cabinet | More Data
4 South | 02 | 08 | Blah
--------------------------
I am able to get the concatenation to work fine for the first sheet
(=[A3] & [B3] & "." & [C3]), but it just repeats that value
(North01.05) on each page. How can I make Excel reevaluate this
formula for each page (i.e. =[A4] & [B4] & "." & [C4] for page 2)?- Hide quoted text -

- Show quoted text -