VB script help

[sfsteve002]

Hi,

I need some help building a script that will create individual workbooks based on data from one sheet. The data need to be copied to the new file based on the store number and the file name will be a combination of company name followed by location ID and store ID. With the sample below, the script would create three files (Abc company10171.xls,111 company33233.xls,Smith Company635162.xls). There will be over 50 companies and the location ID and store ID will always be unique the same for each

Location ID Store ID Company Name Data
10 171 abc company Details
10 171 abc company Details
33 223 111 company Details
33 223 111 company Details
635 162 Smith company Details

 

[VoG]

Maybe Excel Explosion http://www.datapigtechnologies.com/freeware.htm

You would need to concatenate some fields, as explained in the tutorial.