Associate
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.
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.