VBA to create-rename new sheets in a workbook and export them individually as CSV

[chiidzzz]

Hi, I have in the worksheet "AllData", a list of data that is updated every day.
I need a VBA code to copy every 20 rows from this sheet(Alldata) to a new sheet, name it "1", "2","3"...as needed
and then export every created sheet to a new workbook as CSV.
(In this example, 'Alldata' sheet contains 103 rows, the code must create 6 new sheets, named 1,2,3,4,5,6 containing respectively 20,20,20,20,20,3 rows copied from Alldata sheet.
Thank you in advance.

[Bob Phillips]

Cross-posted at ExcelGuru

[p45cal]

and at https://www.excelforum.com/excel-pro...ly-as-csv.html

[chiidzzz]

I am sorry for not reading the forum rules about cross posting, I will edit my post immediately.

[chiidzzz]

To be able to post links your post count must be 5 or greater. Your post count is 2 momentarily
how can I post the links?

[p45cal]

To be able to post links your post count must be 5 or greater. Your post count is 2 momentarily
how can I post the links?

Here the are:
https://www.excelforum.com/excel-pro...ly-as-csv.html
https://www.excelguru.ca/forums/show...idually-as-CSV
http://www.ozgrid.com/forum/showthread.php?t=205786

(While your post count is low you can post them without the http part, they won't be links but enough to allow people to get to them)

[chiidzzz]

Thank you for your reply, and sorry again. Now if someone provided a solution in a different website, should I post it here?