vendredi 3 novembre 2017

Select random rows within specified range based on variable

I am a novice VBA writer and have a request that is too complex for me to map out. Here is a breakdown of what I'm needing a code for:

  1. Select E2
  2. Search column E for all cells that match value of E2 (For i) and select those rows to create a range
  3. Random select 5 rows within that range
  4. Copy random rows and paste in Sheet2
  5. Move to next unique value in column E (Next i)

This code will need a section that uses xlDown on Sheet2 as to not paste over information already listed but I can write that piece.

Thanks in advance, Tiffanie




Aucun commentaire:

Enregistrer un commentaire