I am trying to learn the best way to copy rows based on a column's criteria and name the worksheet accordingly. Below is more detail:
The information is pulled from our intranet site and saved as in excel 2003. The data fills A1:AA500. However this could vary each week. I need to copy all rows which have the same person's initials on column k into a new worksheet and name the worksheet the person's name. For example, if sheet one has 30 rows with ABC in column k, all 30 are copied to a new worksheet and the worksheet is named Albert (the A in ABC). Any help is truly appreciated. Not sure where to start.
The information is pulled from our intranet site and saved as in excel 2003. The data fills A1:AA500. However this could vary each week. I need to copy all rows which have the same person's initials on column k into a new worksheet and name the worksheet the person's name. For example, if sheet one has 30 rows with ABC in column k, all 30 are copied to a new worksheet and the worksheet is named Albert (the A in ABC). Any help is truly appreciated. Not sure where to start.