PDA

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



Beatrix
05-24-2011, 04:44 AM
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
05-24-2011, 07:19 AM
Try this

Beatrix
05-25-2011, 06:41 AM
Thanks very much..

it works perfect!

Cheers,
Yeliz