Transferring cell contents from selected rows only.


Colin Hayes


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



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