Extracting data from a table

[markdonnelly]

Hello all.
I have a table with 6 columns. I need to extract a range of values from one column based on three criteria. Thats is the first three columns are used to filter the table and then I need to extract the data in the one of the remaining columns and write it to a list on to another sheet in the workbook.

I've search through the forum and a lot of suggestions use advanced filters which I have tried and will work fine if I want to extract the whole row. But I can not find a way of extract only a single column. I am not sure if I have missed something but I can not see a way of using the advance filter and limit it to just one column.

Some of the suggested vba code look like they might also work but I am not advanced enough in vba to understand how to edit the code to meet my need.

Is there a way to limit the advanced filter to one colum or do I need to persue another option.

Any advice would be appreciated
Thanks Mark

 

[Andrew Poulsom]

Welcome to the Board.

To extract a single column put the column header in a cell and specify that cell as the output range.

 

[markdonnelly]

Thankyou. That works like a treat. I can not believe it is so simple and I missed it. A lot of the suggested answeres talked about the result but it just did not click. My thanks once again.