Hello,
Glad to know this forum exist. I'm new here and in VBA for Excel. Is there any solution exist on the title above( I searched but no success). What I'm looking or getting help is. I have a multiple data in multiple column in a multiple sheet that I want to paste into a word doc..let says
data1-10 from worksheet1, cell A1 to A10
data 11-12 from worksheet2, cell C4 to C5

and the content of these cells paste into a new word document and place it in a table with vairables

word table format:
column 1
item1. <data1> 'variable define in word' and data from cell A1 paste into this variable
item2. <data2> 'variable define in word' and data from cell A2 paste into this variable

column 2
item1. <data11> 'variable define in word' and data from cell C4 (from worksheet2) paste into this variable
item2. <data12> 'variable define in word' and data from cell C4 (from worksheet2) paste into this variable

column 3
item1. <data3> 'variable define in word' and data from cell A3 paste into this variable
item2. <data11> 'variable define in word' and data from cell C4 (from worksheet2) paste into this variable

....
....

thanks and more power to this forum..