R
redbird77
Hi,
I am having problems with the "Repeat Rows" feature when printing a
worksheet.
It is kind of hard to describe my goal so I've posted a screenshot at
http://home.earthlink.net/~redbird77/images/rows.gif.
I am making an order form that has many different sections - "Trail
Mixes", "Nuts", Fruit" etc. At the top of each page I would like to
repeat the rows for the date to be written in. That row also contains
the name of a section.
My problem is that if I choose to repeat the top 4 rows or so, the
first section on every page will say "Trail Mixes". I can simply
leave the first section name blank, but then I must go back and
hand-write in every section name on the top of each page - uggh.
Is there any way I can have Excel automatically determine the last
section name on the previous page and use that as the first section
name on the following page? I figure I could rig something up using
VB, but is there an easier way.
Thanks in advance,
-redbird77
I am having problems with the "Repeat Rows" feature when printing a
worksheet.
It is kind of hard to describe my goal so I've posted a screenshot at
http://home.earthlink.net/~redbird77/images/rows.gif.
I am making an order form that has many different sections - "Trail
Mixes", "Nuts", Fruit" etc. At the top of each page I would like to
repeat the rows for the date to be written in. That row also contains
the name of a section.
My problem is that if I choose to repeat the top 4 rows or so, the
first section on every page will say "Trail Mixes". I can simply
leave the first section name blank, but then I must go back and
hand-write in every section name on the top of each page - uggh.
Is there any way I can have Excel automatically determine the last
section name on the previous page and use that as the first section
name on the following page? I figure I could rig something up using
VB, but is there an easier way.
Thanks in advance,
-redbird77