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! :)

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

---

Hi!

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