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
Bookmarks