Hi - I've scanned through all the relative posts and iterations, and have probably started to confuse myself!
I can get the advanced filter to filter my data on column N to two criteria and copy all rows to a separate worksheet, but I only want to copy rows where both criteria are met.
In other words Col A has an order number, and Col N a schedule of rates code applied for valuation purposes - so what I want to do is highlight those orders where a combination of both rates have been applied.
I hope that makes sense, and would be grateful if any one can signpost me to a solution. I often scour the threads for a solution but am mindful that I often create fairly crude <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym>.
Thanks - Neil
I can get the advanced filter to filter my data on column N to two criteria and copy all rows to a separate worksheet, but I only want to copy rows where both criteria are met.
In other words Col A has an order number, and Col N a schedule of rates code applied for valuation purposes - so what I want to do is highlight those orders where a combination of both rates have been applied.
I hope that makes sense, and would be grateful if any one can signpost me to a solution. I often scour the threads for a solution but am mindful that I often create fairly crude <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym>.
Thanks - Neil