Comments doesnt show up correctly while using Advanced Filtering

[mmandali]

Hello,

Basicly; I have a RAWdata in DATA sheet, and made an extract range for another sheet and filtering with slicers with a basic advanced filter VBA code.

Problem is; I have comments in some of my columns in rawdata table. And all comments are correctly placed in my Filter Sheet IF I DONT FILTER ANYTHING WITH ANY CRITERIA.
When I make a filter; filtered data correctly shows up in my FILTER sheet but THE COMMENTS are staying like in the RAW data.

So that causes a missmatch between row and comment info. Any ideas how I can make that filtering with the correct comment information.

[PCI]

Can you give an example of the issue explaining step by step what you are doing and what is wrong