I have a sheet with the columns below:
<colgroup><col><col></colgroup><tbody>
</tbody>
I would like to do the following:
1. copy the 'master sheet' based on the number of unique values in Column "DC". In this case, this would be 4 additional sheets.
2. name the sheets based on this list (which I can do but including this for a wholesome picture)
2. delete any rows that does not belong in a given tab. (e.g. tab DC 1 will only have one row, for Item # 1. Tab DC 3 will have 3 rows)
Thank you in advance!
DC | ITEM # |
DC 1 | 1 |
DC 2 | 2 |
DC 3 | 2 |
DC 3 | 3 |
DC 3 | 4 |
DC 4 | 1 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I would like to do the following:
1. copy the 'master sheet' based on the number of unique values in Column "DC". In this case, this would be 4 additional sheets.
2. name the sheets based on this list (which I can do but including this for a wholesome picture)
2. delete any rows that does not belong in a given tab. (e.g. tab DC 1 will only have one row, for Item # 1. Tab DC 3 will have 3 rows)
Thank you in advance!