I have an existing sheet where I would like to use VBA to .
1) filter names entered in column H,
2) create a new sheet in the open workbook containing all rows matching the first name in column H (each name has multiple associated rows but in some occasions will have no rows),
3) and loop for all names in Column H.
Currently, I have concrete references to the names which must be manually updated should additions or deletions be made. My hack job at coding has resulted in a mess with little results (ergo, my lack of posted code).
Thanks for the assistance!
1) filter names entered in column H,
2) create a new sheet in the open workbook containing all rows matching the first name in column H (each name has multiple associated rows but in some occasions will have no rows),
3) and loop for all names in Column H.
Currently, I have concrete references to the names which must be manually updated should additions or deletions be made. My hack job at coding has resulted in a mess with little results (ergo, my lack of posted code).
Thanks for the assistance!
