Simple Excel question

reefoid

reefoid

reefoid

Associate
Joined
18 Oct 2002
Posts
2,055
Location
Southend-on-Sea
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.
 
create a 3rd sheet and add the formula

=Sheet1!A1 & " " & Sheet2!A1

if he has renamed the sheets replace sheet1 and sheet2 with what ever he has called them..

is that what you need?
 
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.
 
A little bit of VB scripting will sort this one. A For, Next cluster in a macro can be used to feed the information in and instruct it to print.

Email it to me: onceuponadaydream at hotmail dot com and I'll have a quick mess around. Off work ill again today so need something to keep my brain alive.
 
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!!
 
You must log in or register to reply here.
Back
Top Bottom