Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Repeat formula on each page

2 views
Skip to first unread message

meznak

unread,
Jun 8, 2007, 12:53:34 PM6/8/07
to
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)?

Tom Ogilvy

unread,
Jun 8, 2007, 2:06:00 PM6/8/07
to
Print each page individually. Adjust the formula before printing.

--
Regards,
Tom Ogilvy

meznak

unread,
Jun 8, 2007, 4:23:50 PM6/8/07
to
As I'm looking at several hundred cabinets, that is not an option.
Any other ideas?

On Jun 8, 11:06 am, Tom Ogilvy <TomOgi...@discussions.microsoft.com>
wrote:

Mark Lincoln

unread,
Jun 8, 2007, 4:46:39 PM6/8/07
to
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

> > > formula for each page (i.e. =[A4] & [B4] & "." & [C4] for page 2)?- Hide quoted text -
>
> - Show quoted text -


0 new messages