Transferring cell contents from selected rows only.


C

Colin Hayes

Hi

I have a workbook with 12 worksheets , one for each month of the year.

In each worksheet I have names and address details for people I
sometimes need to write to.

I've made up a template letter in worksheet 13 which I want to use and
send only to certain people I've marked in worksheets 1 to 12.

I can't work out how to transfer the name and address details for the
highlighted row to the template sheet - can someone help? I need to know
what code to put into the template sheet.

The idea would be that I highlight a row in say worksheet 2 , and then
it transfers that person's details into the template in worksheet 13
ready for me to print out my letter.

Grateful for any assistance.


Best Wishes


Colin
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top