VBA to split list and save into individual desired workbook format

[ec4excel]

I had a VBA (for another purpose) to split data into individual workbook but I am not able to change the handler from Column A to column D and save as file name for this job.

Next, before saving the individual workbook, can I at the same time add in some steps to "make" the data into a custom format instead of opening each workbook and run another vba in each workbook?

The original VBA only filter and save the filtered file as it is and closed the workbook and go for the next wb.

I had indicated what i need to do in the Workbook and below are the steps.

What I need are:

In WS "Original Data":

1. Before saving as individual file, I need to check the "serial" number in Column I, original data is in TEXT form. Needs to first convert this column into number and do a check whether the numbers skipped or not. How to notify us that there is a skipped in the sequence?

2. To split the workbook, there is a helper in Column M and the original helper is in Column A, but for this file, the helper is in Column D.

What I need in the new workbook:

To use a "helper" to indicate the begin date and end date (where can I put this helper? In which Workbook?)

1. To insert in A1 of the new WB, "From xx/xx/xxxx to xx/xx/xxxx"
2. To create a running serial number from A3

To create "Product-Wise Summary"

To find the last row after A3, skipped 1 row and add in wordings in Column A, "Product-Wise Summary"
To find "Product-Wise Summary" and insert wordings "Fuel" 1 row below it.
To find "Fuel" and insert wordings in column B (Total Amount) and C (Quantity Litre) next to "Fuel"
To find "Fuel" and insert wordings (Diesel) in column A 1 row after Fuel
To sum Column F on Column B and C next to "Diesel"
To find "Diesel" and insert wordings (Total) in column A 1 row after Diesel
To sum Column F on Column B and C next to "Total"

To create "Dry Product-Wise Summary"
To repeat same steps above but have 1 more line of wordings "No dry sales for given period."

To create "Payment Mode Summary"
To repeat the same steps as "Product-Wise Summary"

Last, to save the wb as per the name on Column D and the end date helper and continue to filter and save the wb for the rest of the fleet.