Solved: pulling data from different columns based on specific data in one column

[Beatrix]

Hi All ,

I attached the sample spreadsheet..please see below.

I need to pull the data from seperate columns C,F,G,H,I,J,L,M in Actions tab to the table in Sheet1. The records need to be copied from one sheet to another are only open records which have a x sign in column L in Actions tab.

I have been trying to create a dynamic structure for this. I was wondering is there any MS Excel function to do this rather than to use VBA?

Cheers,
Yeliz

[Bob Phillips]

Try this

[Beatrix]

Thanks very much..

it works perfect!

Cheers,
Yeliz