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:
- Select E2
- Search column E for all cells that match value of E2 (For i) and select those rows to create a range
- Random select 5 rows within that range
- Copy random rows and paste in Sheet2
- 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