+ Reply to Thread
Results 1 to 2 of 2

Putting fields into a header

Hybrid View

  1. #1
    Registered User
    Join Date
    04-19-2006
    Posts
    2

    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

  2. #2
    Registered User
    Join Date
    04-19-2006
    Posts
    2

    re phrase

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1