Results 1 to 3 of 3

Thread: Print Multiple Sheets With Different Cell Data For Each PrintOut

  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Print Multiple Sheets With Different Cell Data For Each PrintOut

    Hi Guys, I've really got no idea how to phrase this but I need some help.

    I have a few files in excel where I've got to print out like about 10 copies with each copy having a name of the recipient.
    There is a cell where I'll type the person's name and then print.

    Now, after each printout, I've got to manually change the name and the print.

    What I would like to ask is whether is it possible to write the names in a list and then "do something" that makes it possible to read the list and print each copy with the name?

    I'm not sure if this can be achieved or anything as I'm not really someone who knows about excel that much.

    I usually Google for helps but this time, I can't seem to find any help about this.

    The only thing I can search and get is about a macro that helps to increment a cell value for every print.

    Is this achievable for a list of names?


    Regards!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Yes this is achievable. The following code is just based on assumptions.

    Code:
    Sub PrintForEachValue()
        Dim rng As Range
        Set rng = Worksheets("ListOfNames").Range("A1:A10")
        For Each rng In rng
            ActiveSheet.Range("A1").Value = rng.Value
            ActiveSheet.PrintOut Copies:=1
        Next rng
        Set rng = Nothing
        
    End Sub
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0
    Hi!

    Thanks for the awesomely quick response, I'll try this code out soon!

Similar Threads

  1. Replies: 7
    Last Post: 05-08-2013, 07:12 PM
  2. Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  3. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 PM
  4. Replies: 2
    Last Post: 11-08-2012, 01:15 PM
  5. Replies: 7
    Last Post: 03-06-2012, 07:49 AM

Posting Permissions

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