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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,114,069
Messages
5,545,803
Members
410,708
Latest member
SanTrapGamer
Top