Can someone help me with a vba code for the following:-
1. Randomly pick “n” no. of files (given in D15:D19 of sheet 4) from sheet 1 and paste in Sheet2.
In the given eg:- the following are the no. of files to be picked
safety_invoice_only - 54
safety_personal_care – 32
safety_electrical_equipment – 1
safety_baby_products - 14