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