Filter duplicate values

[madhatter40]

Hello,

I was wondering if someone could help with this problem. I have a workbook that has multiple sheets and I want to combine unique values onto separate sheet. I have attached a workbook with sheet 1 and sheet 2 having values and I want to have unique values on sheet 3 from the other sheets.

[GeneralDisarray]

put this in the workbook you need to combine:

Please Login or Register  to view this content.

You'll may need to edit what I've highlighted. Try the button I put on Sheet3 in the attachment.

[madhatter40]

That does work great. Is there any way to have it look at a different column (Column E)? I forgot to add that is my original post.

[GeneralDisarray]

Yes, please upload a more specific example to work on.

[GeneralDisarray]

If you mean, have it remove duplicates based on column e, then I think you would just need to change the 1 to a 5 here:

Please Login or Register  to view this content.

But, without an example to test it on, I'm not sure if that's what you mean.

[madhatter40]

here is the same workbook with values in column E

[GeneralDisarray]

Ok, the code works on your example - but I'm assuming your actual sheet has more columns to worry about.

My code dumps the values in the used range to the sheet, starting in the first column. So when you moved the single column to E it still ends up in A on the 'Sheet3' because it's one column wide.

So, think of it like this, the number below needs to be where the results END UP on 'Sheet3' after the combining. That should be all you need to edit.

Please Login or Register  to view this content.