Auto-Populate a Sheet Based on Criteria in Another Sheet

[Rwetta]

Hello all,
I am creating a spreadsheet that I need auto populated off of criteria in another spreadsheet that has data that is imported from another source.

The first tab is events 2014 and is automatically downloaded from our servers. The second tab is the table I need populated based off of criteria in the first tab. I need it to populate the rows on the table with data on the rows that say DROPPED OBJECT in Collumn DT on the first tab.

If the cell in collumn DT says DROPPED OBJECT i need it to return the data in same row from collumn H,L,N,P to the second tab.

I have attached the spreadsheet for reference. any help will be appreciated.

[davesexcel]

Try this!!

Please Login or Register  to view this content.

See the attached, I just hid the columns so I could see what was going on and deleted all the columns that you were not using, bringing the size of your workbook down to 26 kb.