Conditionally Copy Multiple Rows

[dsol828]

Hello all,

I've been looking for a way to solve an excel problem of mine with little success.

I have a large table and would like to copy only the rows with a specific value.
My problem is that the value I'm looking for can be found in one of two columns.

Most of the autofilters i've come across only search for the value in one column.

Would anyone be able to provide some Macro or similar code?

Thanks!

 

[Sektor]

1. Get last row of data.
2. Autofilter one of these two columns.
3. Copy only visible cells with SpecialCells(xlCellTypeVisible).
4. Remove autofilter.

Then filter another column.

 

[SydneyGeek]

Have you used Advanced Filter before? It lets you filter for the same value across multiple columns if you need to.
This page has some examples to get you started.

Denis

 

[dsol828]

Thanks for the answers guys.

That advanced filtering is by far the easiest way to get there. Had no idea there was already a tool for that within Excel.

Thanks!