Comments dont show up correctly while using Advanced Filtering

rasmon

New Member
Joined
Apr 24, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,114,652
Messages
5,549,210
Members
410,905
Latest member
Extjel
Top