Need assistance on Macro for multiple criteria (Allocation Macro)

Hey there,
I hope you are doing good.

Attached is the sample file for the "Flecha Audit Sample" to allocate to the team.

It's a total of 10390 Records available in the attached excel. However, it was not the constant number we received every week. So the actual data should meet a few criteria so that I can allocate the data to the team easily.

There are 76 unique Rules with "10390" ASIN IDs.

Criteria 1 - Macro should create a new sheet and paste the all unique rules and ASINs (Count of asin_id) for those rules from "Raw Data". (Basically, need a macro of what actually pivot table will do)

There is a sheet called "Indetail" in the attached file.

Criteria 2 - Whatever number I enter in the "should divide" column that many records should be separated into the new sheet and the remaining into another sheet. For instance, If there are "1464" ASINs present for one "rule_name" then if I enter "100" in the "should divide" column then 100 records should copy to a new sheet, and the remaining "1364" records should be copied to another sheet. (This should not pick the top 100 or bottom 100 instead they should pick at random).

Please review and assist with this...

Thanks in advance .

Flecha+Audits+-+FP+Sample+-+Nov+2022 (1).zip

Hello. Please, you must confirm what I am going to ask you:

Do you want the macro to add 152 sheets to the workbook?...

Without a doubt: now it is much better explained and the example in post #1 is much better.

For Criteria1: results in "Test"

Note: i had to amend data for B0BN38R3HQ3/SC/RestrictedProducts/Regulated/UK_Prohibited_Petrol_Cans_FP22022-11-22 06:19:43

to

B0BN38R3HQ3/SC/RestrictedProducts/Regulated/UK_Prohibited_Petrol_Cans_FP2022-11-22 06:19:43

to fit with all entries

Please Login or Register  to view this content.

There is no code for the second criteria: the post was just for the first!

For the split, are you selecting just ONE of the 76 for analysis? and if so, how are you going to make the selection?

Please Login or Register  to view this content.

the ID (selection) and "Should Divid" umber are hard-coded so I need to know how these are selcted.

Macros called from "Dasboard"

Added possibly selection method in "Dashboard" (no code added for this).

Originally Posted by Pawan Sai

Any update on this??

Time to time, my friend!...

Don't forget that you entered the new year 8 hours and a half before us and here we not only celebrate that but also celebrate (and will celebrate for the next 4 years) the World Cup in Qatar (Jajaja).
'_________________

Regarding your request, see what I have attached:

Please Login or Register  to view this content.

Originally Posted by Pawan Sai

I really appreciate your efforts in resolving queries. This was the exact code I was looking for.

And in the same way: I wish you a very happy new year 2023.

You're welcome and thank you for the rep.