Random Audit Macros

dctaillefer

New Member
Joined
Apr 27, 2019
Messages
1
I have a page with 652 lines on it which I have to randomly audit. In column “B” are the 3 different regions, and in column “G” are the client names. I need to audit 25% of each region, inclusive of ALL the duplicates.

Total count:

652 lines with 51 duplicates; 27 in region A, 6 in region B, 18 in region C.

Region A: 352 @ 25% = 88 – 27 duplicates = 61

Region B: 83 @ 25% = 21 – 6 duplicates = 15

Region C: 217 @ 25% = 54 – 18 duplicates = 14


How do I create a macros that when run, will copy all of the duplicate lines put them in a separate sheet, and then copy and place in this sheet the additional randomized lines (meeting the grouping criteria, to get to 25% of total for each group).

I'm spending a fair amount of time, just formating, sorting, counting, and manually (randomly) picking lines... I figure that there must be a way to automate.

Does this make sense, and is it possible?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,122,529
Messages
5,596,695
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top