Randomly pick “n” no. of files from a data

  • 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

  • [cp]*[/cp]

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!