Adv. Filter + Self Referencing in VBA

[MEDERIK]

Hello everyone,

I hope you'll be able to help me with this advanced filter and Self Referencing problem.
Everything is detailed in the attached pdf.
I've also attached 2 example files showing the results of the Self Referencing before and after.

Thank you in advance

Best regards

[JohnTopley]

Please Login or Register  to view this content.

Code below is sheets("Output")

Please Login or Register  to view this content.

Sample solution: Comments entered in "Output" are recorded in sheets "Comments".

The macro uses "Code" as a "key" but this not sufficient as I note your example includes entries with same Company/Code/Country so a unique key is required in order the do the correct match with entries in "Comments"

Macro executed for "Filter" button in "Data"

[MEDERIK]

Hello JohnTopley,


In my personal file, I have a column with unique values, sorry I should have added it directly to my example file
I'll test everything and come back with an answer
Thank you very much for your invaluable help,
I'll test your code on my personal file and come back as soon as I've finished.

Many thanks

Best regards

[JohnTopley]

Thank you for the update.

[MEDERIK]

Hello JohnTopley,
I've tested your code and it's great in the example that I presented in my 1st message,
But as indicated in my 2nd message, I actually have a column with unique values.
I've adapted the example file with this new column
The big question is, with a column of unique values, is it possible to avoid using a "Comments" sheet ?
I uploaded a 3 pdf with the results of the tests I carried out.

Can you please adapt your code to this new approach?
The result in test 3.pdf is what I would have liked to see

Thank you in advance

Best regards

[JohnTopley]

You have to keep the "Comments" somwhere so where do you want them?

[MEDERIK]

If this is not possible in the "Output" sheet, then in "Comments"
Best regarss

[JohnTopley]

Where is the unique column in "Data"?

[MEDERIK]

I've put unique values in the "Company" column,
To simplify, I've put 1,2,3,4...etc

Best regrds

[JohnTopley]

Comments placed in "Output" (N:R) but in my opinion, they are better in a separate sheet.

[MEDERIK]

Hello JohnTopley,
You're great
A huge thank you for this new request that I will test at the end of the day.
Y
ou are probably right about the comments in another sheet,
Will I be able to use your 1st version or do I need a 3rd version for that ?

Thanks in advance
Best regards

[MEDERIK]

JohnTopley,
It's really impressive how well you've mastered VBA,
The code is pure and superbly structured,
I've tried to put the comments on the "Comments" sheet myself, but I can't do it.
If you don't mind, could you please send me this new version
Many thanks
Best regards

Thank you very much

[JohnTopley]

See attached

Please Login or Register  to view this content.

[MEDERIK]

I don't know how to thank you
You're brilliant
Many thanks again
Have a nice evening

[JohnTopley]

You're very welcome and thank you for the rep