I'm trying create a follow up list based on 1 criteria.
I have an idea of creating one but do not think it will be the most efficient.
(thought about indirecting all the data onto sheet2 then pulling it from there)
Basically, as you see in the attached photos, sheet 1 contains the data.
In sheet2 starting at A2, I want excel to look in sheet1 and pull
the property code, street, city, state,......follow up? (basically all the columns), only if it says Yes for follow up for each property code.
The second photo (sheet2) is how I would like the sheet to look like.
I need the most efficient way of doing this for many data tabs.
Any help will be most appreciated.
Sheet1:
Sheet2:
I have an idea of creating one but do not think it will be the most efficient.
(thought about indirecting all the data onto sheet2 then pulling it from there)
Basically, as you see in the attached photos, sheet 1 contains the data.
In sheet2 starting at A2, I want excel to look in sheet1 and pull
the property code, street, city, state,......follow up? (basically all the columns), only if it says Yes for follow up for each property code.
The second photo (sheet2) is how I would like the sheet to look like.
I need the most efficient way of doing this for many data tabs.
Any help will be most appreciated.
Sheet1:
Sheet2:
