| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal in header
Hi All,
I have a sheet subtotalled by column E with page breaks. I'd like to display the value of column E on a particular page in the header of that page. How can I do that? E.g. Page1 (requested value in header: AC06) A B C D E F 2006.05.22 5 98 24/2006 AC06 2 000 2006.05.22 5 98 26/2006 AC06 2 000 AC06 Subtotal 4 000 Page2 (requested value in header: BB08) 2006.05.18 5 96 0054187 BB08 44 800 2006.05.18 5 96 0054188 BB08 40 250 2006.05.19 5 97 0054195 BB08 42 840 BB08 Subtotal 127 890 Thanks, Stefi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
