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

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    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!