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
 

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

Similar Threads

Display data for rows where cell consists of whole number 1
Copy a range data from 1 sheet to multiple selected sheets 1
Adding a row to reconcile to a new worksheet 1
How do I automatically rename a sheet from the summary page? 1
How do use a template for different worksheets in workbook 1
Pop-up box 2
Printing and emailing query 2
Create new worksheet from template for each value in range 6

Top