Hi all,
I am going to need to find the syntax for vba that takes a list of examples from excel cells and inputs them into the corresponding places within a word template.
So in word i have a table somewhat like this :
Pricing Transparency Examples
PROCEDURE LOCATION1 Market Analysis
Location Rate Rate Type
[HIGH COST PROVIDER1] $ [CASE/ %]
[MIDDLE COST PROVIDER1] $ [CASE/ %]
[LOW COST PROVIDER1] $ [CASE/ %]
*Total Savings of $[SAVINGS1] could be achieved between high cost and low cost service providers.
and in excel i would have a list like:
Colonoscopy Little Rock, AR
Baylor 2000
Medical Center 1500
Endoscopy Center of Dallas 500
and so forth
So i would like to know how can i make a template in excel that will identify the first procedure in a list (colonoscopy),
fill that into Procedure1, the city into Location1, etc.
I would love to learn the syntax so that I can apply this to other types of reports I normally have to transcribe over to word.
Thank you very much for your help!
Bookmarks