J
John in TennSC
I have a 3 sheet workbook (contractor billing forms) and
wish to insert a Word "Form" (Release of Lien) into a 4th
sheet and have the inserted "form" filled in by data from
the other workbook sheets.
The workbook transfers all redundant data into the other
2 sheets. The data is completed, then copied and renamed
the next month [sequentially, ie: JobBill#1, JobBill#2,
etc.] using the prior month as the starting point.
The Release of Lien form could also use this redundant
data, but I haven't been able to figure out how to get
the Word "fields" to update without a specific filename
reference (see sequential use above). Also, the verbage
in the "fields" occasionally varies in length (laying out
the text over the worksheet's cells hasn't worked very
well). The last consideration is we have 2 version of
Office (2000, 2002 [XP]).
How can I link the inserted Word Form's "fields" to
specific Excel, ='Sheet'!Cell, references?
wish to insert a Word "Form" (Release of Lien) into a 4th
sheet and have the inserted "form" filled in by data from
the other workbook sheets.
The workbook transfers all redundant data into the other
2 sheets. The data is completed, then copied and renamed
the next month [sequentially, ie: JobBill#1, JobBill#2,
etc.] using the prior month as the starting point.
The Release of Lien form could also use this redundant
data, but I haven't been able to figure out how to get
the Word "fields" to update without a specific filename
reference (see sequential use above). Also, the verbage
in the "fields" occasionally varies in length (laying out
the text over the worksheet's cells hasn't worked very
well). The last consideration is we have 2 version of
Office (2000, 2002 [XP]).
How can I link the inserted Word Form's "fields" to
specific Excel, ='Sheet'!Cell, references?