Putting fields into a header
 

I have written a simple spreadsheet for my colleagues at work to use to
keep track of their equipment orders, I have been asked to double it up
to select new enrties and print it off as an order form. I have added a
header with address and logo but need to add the department details.
This information ois held in cells B2:C3. I am trying to add a command
to place cells B2:C3 into a header so that when different users use the
master spreadsheet and change their department description and or
username this information will print along with the section of the
spreadsheet they have selected to print. This will save me having to go
to each department to do an individual header. All they need to do is
add their name and department. It's simple. But how do you do it?!!! I
have also discovered that it is no good selecting multiple sections of
the sheet as it uses a new page for each one which is no good. Hope
this makes sense.
Kind regards
Phil Wilson


--
pjahw
------------------------------------------------------------------------
pjahw's Profile: http://www.excelforum.com/member.php...o&userid=33660
View this thread: http://www.excelforum.com/showthread...hreadid=534344

Putting fields into a header
 

Could there be another way without using a header?
Could I, within print settings, enable some of the cells to be printed
on each page automatically without using the header facility?
I realise I'm being lazy but the thought of having to change details
and save a new spreadsheet every time a new member of staff arrives or
a new budget has to be set just makes me put my head in my hands and
weep!!
Phil


--
pjahw
------------------------------------------------------------------------
pjahw's Profile: http://www.excelforum.com/member.php...o&userid=33660
View this thread: http://www.excelforum.com/showthread...hreadid=534344