LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default setting up common headers

I have a template set up that displays and prints six reports. Each report
contains a header showing:

Name of Client
Account#
Title of Report
Date Range of Report


Currently I have the header set up in each worksheet and I input the data
for each report.

I'd like to streamline this if possible,

The client name and number remains the same across all reports

The Title is specific to each report and does not change.

On some reports the date is a range and others it is either the beginning or
ending date of the specified range.


I'd like to input the Name, Number and date range once and have it displayed
in each report.

I was thinking I could have a specific worksheet just for the header, do all
the stuff there and then combine it during print but can't see how to do
that.

Any thoughts?

Thanks,

Vic Baron

--
There are 10 kinds of people - those who understand binary and those who
don't

 
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
Combining two ranges based on common a common value ahmed[_3_] Excel Discussion (Misc queries) 5 April 18th 09 05:04 PM
lookup using column headers and row headers Memphus01 Excel Discussion (Misc queries) 1 April 13th 09 04:57 PM
Most and least common jmj713 Excel Discussion (Misc queries) 2 April 3rd 09 02:59 AM
Common footer but not common margins please -(Page 1 of 2) etc RajenRajput1 Excel Discussion (Misc queries) 9 August 26th 08 06:56 PM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM


All times are GMT +1. The time now is 02:38 PM.

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"