Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Xanth
 
Posts: n/a
Default having problems with autofill on each sheet

Hello all,

I am having a problem and here it is in a nutshell.

I need to create a form that will have several "titles" (wording) on the top
of each page that lines up with each row.

i.e. A would be name, B would be signature, C would be member, etc for as
many as needed.

I have started a sheet with the needed information and I have about 150
names that need to be listed, so obviously it will be several pages.

I can not figure out how to have the information appear on each page at the
breaks, and I also need to be able to add names or delete names as
necessary.

Headers do not work for me as I can get then to line up properly.

Is there away for excel to do this?

I have excel 2000

TIA,

Dave-



  #2   Report Post  
RagDyer
 
Posts: n/a
Default

Have you tried:

<File <Page Set Up <Sheet tab,
And enter the rows you wish to repeat in the,
"Rows To Repeat At Top" box?

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Xanth" wrote in message
...
Hello all,

I am having a problem and here it is in a nutshell.

I need to create a form that will have several "titles" (wording) on the top
of each page that lines up with each row.

i.e. A would be name, B would be signature, C would be member, etc for as
many as needed.

I have started a sheet with the needed information and I have about 150
names that need to be listed, so obviously it will be several pages.

I can not figure out how to have the information appear on each page at the
breaks, and I also need to be able to add names or delete names as
necessary.

Headers do not work for me as I can get then to line up properly.

Is there away for excel to do this?

I have excel 2000

TIA,

Dave-



  #3   Report Post  
Xanth
 
Posts: n/a
Default

RD-

Thanks for your help, it did the trick.

Dave-


"RagDyer" wrote in message
...
Have you tried:

<File <Page Set Up <Sheet tab,
And enter the rows you wish to repeat in the,
"Rows To Repeat At Top" box?

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Xanth" wrote in message
...
Hello all,

I am having a problem and here it is in a nutshell.

I need to create a form that will have several "titles" (wording) on the
top
of each page that lines up with each row.

i.e. A would be name, B would be signature, C would be member, etc for as
many as needed.

I have started a sheet with the needed information and I have about 150
names that need to be listed, so obviously it will be several pages.

I can not figure out how to have the information appear on each page at
the
breaks, and I also need to be able to add names or delete names as
necessary.

Headers do not work for me as I can get then to line up properly.

Is there away for excel to do this?

I have excel 2000

TIA,

Dave-





  #4   Report Post  
RagDyer
 
Posts: n/a
Default

Appreciate the feed-back.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Xanth" wrote in message
...
RD-

Thanks for your help, it did the trick.

Dave-


"RagDyer" wrote in message
...
Have you tried:

<File <Page Set Up <Sheet tab,
And enter the rows you wish to repeat in the,
"Rows To Repeat At Top" box?

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Xanth" wrote in message
...
Hello all,

I am having a problem and here it is in a nutshell.

I need to create a form that will have several "titles" (wording) on the
top
of each page that lines up with each row.

i.e. A would be name, B would be signature, C would be member, etc for as
many as needed.

I have started a sheet with the needed information and I have about 150
names that need to be listed, so obviously it will be several pages.

I can not figure out how to have the information appear on each page at
the
breaks, and I also need to be able to add names or delete names as
necessary.

Headers do not work for me as I can get then to line up properly.

Is there away for excel to do this?

I have excel 2000

TIA,

Dave-





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill Sheet names? Anauna Excel Discussion (Misc queries) 2 February 16th 05 09:10 PM
Am trying to make a time sheet and having problems with a formula. godnight Excel Worksheet Functions 2 February 14th 05 01:21 PM
Cell reference problems with Summary sheet McIntyre Excel Worksheet Functions 3 December 30th 04 05:29 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"