LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default creating repeating headers in a worksheet

I need to create a worksheet with a headline that repeats over several rows.

The items in this worksheet need to then be sorted by date and divided into
week beginning sections

ex. row 1 headers Company Product amt.....
Row 2 Week beginning
Row 3 thru 10 then has info for this week

Row 11 would repeat headers
row 12 Week beginning
row 4 thru ? has info

This will then repeat for each week throughout a full year

How do I create these permanent headers that can have an arbitrary # of rows
under each one?

Any help would be greatly appreciated. If I could figure out the template
then it would save me tons of typing/copy and pasting and then I would like
to figure out How I could then enter data and have it sort itself into the
correct week.
 
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
headers in worksheet Aamir Excel Worksheet Functions 4 November 12th 06 07:04 PM
Repeating a Macro For Each Selected Worksheet carl Excel Worksheet Functions 0 January 11th 06 10:07 PM
Repeating the Row Headers on each page TS Excel Discussion (Misc queries) 1 December 6th 05 08:16 PM
Headers on every worksheet lockwood33 Excel Worksheet Functions 1 July 8th 05 07:17 PM
Repeating Column Headers And Blank Worksheets With Fomulas Konax Excel Discussion (Misc queries) 1 January 1st 05 02:45 AM


All times are GMT +1. The time now is 09:17 AM.

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

About Us

"It's about Microsoft Excel"