Hello.

Im trying to take a large excel file and basically have it do this.

It is setup as follows.

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