B
bb
Hello.
Im trying to take a large excel file and basically have it do this.
It is setup as follows.
| PartNumber | MFG | Pole | Amp | Volt | Price|
xyx,mfg1,3,5,1,10
xxx,mfg2,3,5,11,25
.....
and continues.
What i want to do is have a html template file that excel opens.
This template file would have variables to be replaced in random
places $$PartNumber$$ $$MFG$$ for example would be replace.
What i need excel to do is go through each row individually, select
the 6 columns of data, replace the $$MFG$$ with the excel data for
that row, save it as an html file named by its PartNumber and loop
down each row creating a new html file for each row's data.
Anyone know of any tools or macros that can help me with this?
Thank you so much.
Matt
Im trying to take a large excel file and basically have it do this.
It is setup as follows.
| PartNumber | MFG | Pole | Amp | Volt | Price|
xyx,mfg1,3,5,1,10
xxx,mfg2,3,5,11,25
.....
and continues.
What i want to do is have a html template file that excel opens.
This template file would have variables to be replaced in random
places $$PartNumber$$ $$MFG$$ for example would be replace.
What i need excel to do is go through each row individually, select
the 6 columns of data, replace the $$MFG$$ with the excel data for
that row, save it as an html file named by its PartNumber and loop
down each row creating a new html file for each row's data.
Anyone know of any tools or macros that can help me with this?
Thank you so much.
Matt