Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel 2000 Page Numbering?!?!?!?!?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have an Excel spread sheet for a form that we are going to print out for people to manually fill in. There is a cell on this form that contains a item number that everything else that manually gets filled in relates to. I want to print out (for example) 100 copies of the form and I would like to be able to sequence this number on each printed copy. For example the first (master) form has 1001 in the cell. If I print several copies I want to have the printed copy show 1001, 1002, 1003, 1004... etc. I can do this similar thing with a Word doc by using mail merge but I cannot find a way to do it in Excel.

    Any ideas?!?!?!?!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya,
    Not sure if this will help, but if you had a macro to do the printing, then you could increment the value in that cell each time it prints. For example, if your value was in Cell A1, then:

    For i = 1 To 100
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
    Range("A1").Value = Range("A1").Value + 1
    Next i

    Hope this helps
    AJ

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I send letters to billions of people and im lazy so yes this kind of thing can be done all in Excel, like merge from data table... via template in same wkbk.. save files as unique name and so on...

    can be done... any good

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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