Repeat formula on each page

  • Thread starter Thread starter meznak
  • Start date Start date
M

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)?
 
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

meznak said:
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.
Click to expand...
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
--------------------------
Click to expand...
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)?
Click to expand...
Click to expand...
 
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.
Click to expand...
meznak said:
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 -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top