Copy Partial Row

[ayvee0]

Hi,

I have a spreadsheet which has two sheets. Sheet 1 has two columns of data (A and B)
Column A has some term and Column B has the category that the term belongs in

A B
rrrrrr T
nnnn T
kkkkkk Y
lllllllllll Z
ffffffff Y

In Sheet 2, I have three columns (A, B, and C) except these columns have the terms T, Y, and Z in row 1
So,

A B C
T Y Z

What i want the macro to do is basically check Sheet 1 for which category the term is in (T, Y, or Z) and then copy that term and categorize that term under T Y or Z on Sheet 2.

[ayvee0]

Book2.xlsx

Something like this

[Marcol]

Try this array formula in Sheet2 A3 confirm with Ctrl+Shift+Enter before dragging left and down

Please Login or Register  to view this content.

[EDIT]
@ ayvee0
Care to share how the workbook you posted works?

[natefarm]

This code would do it:

Please Login or Register  to view this content.

[ayvee0]

thank you good sirs