I have 1 "master" sheet that contains all my Test Script records from a database dump - about 6,000 in all (MS-Query creates the sheet data - records are sorted by colA). I want to scroll through the master list of all the records and based on a col A value change (script name) create an Excel file (in the current directory using the script name from col A as the file name). It should contain all the records that were in the range of the script name.
Example, if my data dump consisted of 250 records, (25 unique script names in col A, and each script name covers 10 rows (10 steps in each script) then I want to end up with 25 ".xls" files in the "current" directory (each .xls file will only contain the 10 records for that particular script name - which is also the same name of the .xls file) - i hope i explained that clearly....
Example Psuedo code:
For I = 1 to numberOfRecords
if aI <> aI+1 then create new .xls file with the name value in COL aI
else next I
Example, if my data dump consisted of 250 records, (25 unique script names in col A, and each script name covers 10 rows (10 steps in each script) then I want to end up with 25 ".xls" files in the "current" directory (each .xls file will only contain the 10 records for that particular script name - which is also the same name of the .xls file) - i hope i explained that clearly....
Example Psuedo code:
For I = 1 to numberOfRecords
if aI <> aI+1 then create new .xls file with the name value in COL aI
else next I