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
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