extract sheets from one and auto saved in folder

[adeel1]

Hi all
Need your help to solve my problem
PFA, there is almost more than 2800 numbers in sheet 1 and in sheet 2 there is different 07 format which I mentioned…. I want all 2800 numbers split into different workbooks into 190 each workbook as per which format I selected from 07 in sheet 02..and save at desktop folder (new folder) in EXCEL 97-2003 workbook format…sheets name should be like 1,2 ,3 4, so on….

folder for save: C:\Desktop\New folder (4)

I made one example in sheet 3 for your consideration with format 01

Adeel

[adeel1]

Waiting for some expert opinion....??

[adeel1]

??...can i post some other forums now for solution..??