Simple Excel question

[reefoid]

Hi guys

I hope someone can help, I'm pretty sure this is fairly simple but I rarely use Excel and can't work it out this morning.

I have a spreadsheet with two worksheets. Worksheet 1 contains some address data in two columns - street name and house number. Worksheet 2 is a form which includes two fields for street name and house number.

Basically, I want to be able to print this form and it automatically prints one form for each record in worksheet 1 with the correct address data automatically transferred to worksheet 2.

At the moment, my boss is manually copying/pasting each address, printing, then repeating for all addresses.

Does this make sense?

Any help would be appreciated.

Thanks.

 

[reefoid]

Thanks for the reply. Can you explain what this is doing? I've added it into Sheet3 (other sheets are still called Sheet1/2) but I can't see any change to data anywhere.

Here is some example data just to clarify what I'm trying to do.

Sheet1:
A1 = 1 B1 = Smith Street
A2 = 3 B2 = Smith Street
A3 = 8 B3 = North Street

Sheet2 has lots of info on it, but relevant fields are:

D7 = House Number
E7 = Street Name

So I want a way that with a single click (or as few as possible) Sheet2 gets printed once for each record on Sheet1. I guess its like a mail merge, but just can't work out how to do it.

Thanks.

 

[reefoid]

Sweey, just wanted to repeat my gratitude in my mail on the forum as well. You've been a great help. Sorted my issue out and have been thoroughly nice about it as well!!