My worksheet is grouped by ID#. I'm using the excel subtotals command with page breaks on each group. I need to include the ID# on my report but including the ID# column will make the report too wide. Is it possible to capture the ID# for each group and place it either in the page header or page footer?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Capture a cell value an place in excel page header or footer
- Thread starter sko
- Start date
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question
- Locked
- Question