combine Header worksheet to print with Graph

Microsoft Excel 2007
March 2, 2010 at 09:58:25
Specs: Windows XP
i have inherited a workbook that has 3
worksheets, one with raw data, one called
Graph and another called Header. from the raw
data, a scatter plot is drawn on the Graph
worksheet. i now need to print the Graph
worksheet with the Header worksheet
combined into one. the Header worksheet is 7
rows per page with 2 colums to correspond to
the Graph. Every 8th row is another Header
page increment. (the 7 rows repeat and the
only difference is on the 8-14 rows is
watermarked "Page 2", the 15-21 marked
"Page 3" and so on)

i've selected the print area of the Graph
worksheet, go into Print Preview->Page Setup-
>Header/Footer->Custom Header and tried to
select the "Insert Sheet Name", but i guess
i'm unsure what is needed where it shows
"&[Tab]". i've tried "&[Header]" (without quotes)
among many other alternatives, but nothing

i know this isn't hard, but i am missing
something somewhere. any help would be
greatly appreciated...

See More: combine Header worksheet to print with Graph

Report •

March 2, 2010 at 11:50:11

The text &[Tab] in one of the custom header sections (left, centre or right) will print the worksheet name in that header section. This will result in "Graph" being printed in the header, as "Graph" is the name of the Worksheet.

The custom header and footer commands are limited to what you can enter using the row of icons, (or directly entered text). You can't use the custom header to include rows of data from another worksheet.

If you want to print your Graph after the 7 rows on the header worksheet, you will need to copy the Graph into the right place in the Header worksheet.

You mention that the header repeats several times. Does this mean that there are several versions of the Graph, each using different data.

Just another thought - did the previous owner of this workbook use a macro to print it. Try clicking Alt+f11 (the Alt key and function key #11 pressed together). This opens the Visual Basic window. Look at Project Explorer on the left (if not visible, go to the VB Menu, select View and click Project Explorer). Look for VBAProject(<MyWorkbook.xls>).

Then double click the various elements underneath - each worksheet name, "This Workbook" and if present, any modules (e.g. Module1). If any visual basic code shows up in the large window on the right, you could copy it and post it for someone to review. If posting code please place it between the <pre> and </pre> tags (at the top of the reply box) - they help keep the formatting especially for code.


Report •
Related Solutions

Ask Question