Create worksheets based on value
 

Hi All,

I have two excel files, "SMAC" and "SMACSource". SMAC has a worksheet,
"DATA", that is linked to SMACSource, and another worksheet, "TEMPLATE". The
key column in DATA is "GCN".

What I would like to do, when the application loads, is create a new
worksheet, based on TEMPLATE for each unique value in GCN.

Example:

GCN
16281
16281
16281
20906
20906
22913
22913
22913
22913

So, basically, make a copy of TEMPLATE 3 times and link them to the proper
fields in DATA.

I hope this is enough info to work with; if not, I hope it is enough to give
you a gist of what I'm after so you can ask me some more detailed questions!

Thanks,

Robert