Print same page with different data from a table in another sheet

[GLV]

Hi, everbody,

I am an excel newbie and english is not my 'main' language and i don't even know how to ask google for this need of mine.

As i mentioned in this post's title, i have a Sheet1 with one page in it; in that page i have - let's say - two fields: name and adress (this is just an example).
Then I have Sheet2, that contains a table, with some names and their adresses.

What i need is to print Sheet1 with data from Sheet2, each page with another name and its adress.

Name	Adress
Sam	1st Street
Dave	2nd Street
Ana	3rd Street

After i've printed 1st page, with Sam, I want to automatically print a second page, with Dave, then Ana and so on.

I apollogize if i posted in the wrong section and i hope you understood what i need.

Many thanks !

[AliGW]

Welcome to the forum.

Are you aware that, if you set up a template in Word, you can run a mail merge with the Excel workbook as its source?

If you want to do it all in Excel, you are going to have to learn some VBA coding.

[GLV]

Thanks for the fast response!

You are awesome! The best!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[GLV]

Done and done.

All the best!