marcosis123
New Member
- Joined
- Dec 10, 2019
- Messages
- 12
- Office Version
- 365
- Platform
- MacOS
Hi,
I have a table of data and in column C there are multiple entries of the same data.
I would like a macro to copy the rows containing matching values in C to a new sheet named the value of the data.
So if i had 6 rows that said aa,aa,bb,bb,cc,cc in column C id now have three tabs called aa, bb and cc with the 2 matching rows from the main table in each one.
Cheers
I have a table of data and in column C there are multiple entries of the same data.
I would like a macro to copy the rows containing matching values in C to a new sheet named the value of the data.
So if i had 6 rows that said aa,aa,bb,bb,cc,cc in column C id now have three tabs called aa, bb and cc with the 2 matching rows from the main table in each one.
Cheers