sharadsony
New Member
- Joined
- May 11, 2016
- Messages
- 2
I have some data in an Excel Sheet which have been pull from the master data in another sheet by the VBA. The data is showing in excel sheet as below:
<tbody>
</tbody>
And I have an MS-Word template as detail below:
“ An estimate amounting to Rs. [TA] based on approved rates for the above [Type] was sanctioned by the competent authority. Against this estimate tenders amounting to Rs. [TA] were invited vide Tender No. [Tender No.] Dated [Dated] which has opened on [opened on] . ”
I want to create a macro in the Excel by which the value of different cells of column ‘B’ be paste in template in place of respective [ ] to create a new word doc.
Please help me.
| Column A | Column B |
1 | Type | Ready Mix Concrete |
2 | EA | 5000 |
3 | TA | 4500 |
4 | Tender no. | 272512 |
5 | Dated | 01.06.16 |
6 | Opened on | 07.06.16 |
<tbody>
</tbody>
And I have an MS-Word template as detail below:
“ An estimate amounting to Rs. [TA] based on approved rates for the above [Type] was sanctioned by the competent authority. Against this estimate tenders amounting to Rs. [TA] were invited vide Tender No. [Tender No.] Dated [Dated] which has opened on [opened on] . ”
I want to create a macro in the Excel by which the value of different cells of column ‘B’ be paste in template in place of respective [ ] to create a new word doc.
Please help me.