View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Macro to copy cell data to word document based on an active row?

I have an Excel sheet that has several rows of data.

Is it possible for the user to highlight a cell in column A and then copy
data from that row (specific cells) to a word document that has been
previously created and contains bookmarks?

Excel
A B C D
1 J Smith 65 01/01/04 Mazada 6
2 S Jones 36 03/02/04 Mini
3 G Hall 25 06/06/04 Civic

So the user will highlight one of the rows and then the macro will copy only
the cells A, C, D and place them into the word document

Word
Dear, (name)

Thank you for purchasing (car) on (date)


any help would be greatly appreciated

Brian