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
|