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

Print each page individually. Adjust the formula before printing.

--
Regards,
Tom Ogilvy


"meznak" wrote:

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?

On Jun 8, 11:06 am, Tom Ogilvy
wrote:
Print each page individually. Adjust the formula before printing.

--
Regards,
Tom Ogilvy

"meznak" wrote:
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)?

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

On Jun 8, 4:23 pm, meznak wrote:
As I'm looking at several hundred cabinets, that is not an option.
Any other ideas?

On Jun 8, 11:06 am, Tom Ogilvy
wrote:



Print each page individually. Adjust the formula before printing.

--
Regards,
Tom Ogilvy

"meznak" wrote:
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 -