Macro to extract data into different sheet

[vijanand1279]

Hi,

Is it possible to extract data into different sheet based on the below criterias.

1) To extract all the vendor number in Column G equalling 200000 and 200001 into different sheet.
2) For the rest, extract only 25% in random of the total rows per every USER in column B. (For Example. User Chittoju, Swathi total rows are 39 and data extract for 25% will be 10 rows in random must be copy/paste to different sheet.

I am adding the file for you reference.

Please help!

Regards,
Vijay

[Dimitrov]

I hope this helps. The macro, BreakOutVendors, assumes that the raw data is always in the "For Testing" tab. All the other tabs get generated each time you run the BreakOutVendors macro.

Version03_Deletion.xlsm

Going on vacation!
________________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].

[vijanand1279]

Thank you. It is possible to have all the data extracted in one sheet (tab) (i.e 200000 & 200001 and all users data).
Also, sometime the 25 % count can arrives at 9.5 (e.g. 38*25/100). In that case is possible to extract the count rounding it to 10 instead of 9.

How is the random selection happens when the macro is executed, it helps to know how the random selection is performed every time..

Regards,
Vijay

[Dimitrov]

[1] Note the following sheets:

200000: This sheet holds all users with Vendor Number 200000
200001: This sheet holds all users with Vendor Number 200001
X20 and X21: This sheet holds all users whose Vendor Numbers do NOT equal 20000 and 200001.

[2] In terms of the rounding, I have adjusted the code to round up.

[3] To understand how the rounding selection happens, please refer to and read the procedure in the code called RandomDeletion.

Version05_Deletion.xlsm
___________________________
[A] If this reply was helpful, click the star to the left.
[B] If this reply answered your question, mark this thread as [SOLVED].

[vijanand1279]

So I should run the breakvendors first and the randomdeletion module second ?
I think the "Breakvendors" module works fine. Only thing is after the macro is executed it all the sheets are brought together will be fine. And if the rounding is done will be helpful.

I am not able to understand how or when do I run "Randomdeletion" module as per above suggestion.

[Dimitrov]

[1] Run ONLY the BreakOutVendors. Do NOT run the RandomDeletion by itself. Do NOT run the RandomDeletion separately either. I repeat: Run ONLY the BreakOutVendors. That is all you need to do. That should give you the output that you need. The reason is that when you run the BreakOutVendors macro, it automatically will run the RandomDeletion macro for you.

[2] Yes, as I wrote in my message above, I have changed the code so that the code will round the way you wanted. For example, 9.5 gets rounded to 10.
___________________________
[A] If this reply was helpful, click the star to the left.
[B] If this reply answered your question, mark this thread as [SOLVED].