sharad.sony
06-09-2016, 06:16 AM
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:
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
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 as below:
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
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 as below:
Please help me.