| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat formula on each page
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)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat rows at the bottom of each page contain a formula | Excel Discussion (Misc queries) | |||
| repeat first row at the top of page? | New Users to Excel | |||
| REPEAT ROW HEADINGS ON EACH PAGE | Excel Discussion (Misc queries) | |||
| Can I repeat rows at the top, except the last page? | Excel Worksheet Functions | |||
| How can you get different rows to repeat on each page | Excel Discussion (Misc queries) | |||
Threaded Mode
