extract sheets and 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(Macros will run in sheet 4)..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

 

[Hui]

Adeel

Have you looked at these two possible solutions

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

I think either could be modified to do what you want

 

[adeel1]

dear sir

but i am unable to modify the micros as per my requirement and data splitting into 190 number per sheet not possible in it


adeel