Hey there,

Attached is the sample data for reference.

The workbook contains 2 sheets i.e., Raw data and Allocation sheet.
This is a chargeback allocation that I need to allocate to the team. My query is that... There is a column called "site" (Column L). That needs to be split according to the number I enter in the "Allocation" sheet. For instance, if the total data contains 400 rows and I need a macro where data should split based on the "site" column i.e., HYD 100 and BLR 200. So, whatever number I enter in the "Allocation" sheet should break accordingly, and the remaining data can be deleted.

Please review and do needful. I really appreciate any help you can provide.

Sample file.xlsx