VBA - Extracting unique data based on multiple criteria

Hello All,

Hoping someone can kindly assist with this query.

At present, I am using the following code for extracting unique data (but without any conditions):

Please Login or Register  to view this content.

What I'd also like to be able to do, is still extract the above but only when the values in Sheet1 Column A = Sheet2 $A$1 and Sheet 1 Column K = Sheet 2 $B$1.

Hoping this is possible and that I've appropriately conveyed what I need.

Thanks ever so much for the support.

Thanks sintek, much appreciate your support, however (and apologies) this isn't working and may be due to my lack of clarity.

Where I noted it needed to match values in Sheet 1 Column A, it actually needs to match text, with Sheet 1 Column K being the value.

Hope that helps.

I'm struggling to figure out how to attach something as when I go to do it I'm just seeing a blank white box.

Any ideas?

I have managed to get this VBA to work, though without the desired result.

My originally posted VBA would look at the entire workbook Column A - FJ and provide the unique values from column AC in the next sheet. I need the new one to just do that but with the conditions. The result of the VBA you've kindly provided is filtering as desired but only returning columns 1-12 when I just require column 29.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sintek, you're a legend!

Are you able to remove duplicates from within that code?

Works brilliantly, thank you very much sintek!