I have a data set of 30,000 rows so manual would be tideous.
Is there any way either vba or excel funciton I can extract/select the rows and paste on the next sheet based on criteria of a row?
Ex: if col B, row 1 has 'first name', row 28 has 'first name' and so on all the way down, how can I extract all rows that the words 'first name' in it, and for context: col C row 1 and 28 would have the name.
The reason is that I have cell strings that stay the same but the other column corresponding changes. So when I paste it to the next sheet I have all the 'first names' with the corresponding name.
Any input would be appreciated.