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]

    Rory
    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!