Hi,
So I have a excel sheet with lots of data and information and comment in the cell.
I use filter a lots. My problem is when I filter the comment don't follow, they stay at the location the comment was first created.
I do have a macro that I activate by pressing ctrl+A, that move the comment next to cell where they should be.
My problem is that every single time I use filter I need to re-run the macro.
Is there a way to have a macro or a way that those comment always stay same spot, next to where they where create? Follow the box no matter what the filter it?
Thanks
So I have a excel sheet with lots of data and information and comment in the cell.
I use filter a lots. My problem is when I filter the comment don't follow, they stay at the location the comment was first created.
I do have a macro that I activate by pressing ctrl+A, that move the comment next to cell where they should be.
My problem is that every single time I use filter I need to re-run the macro.
Is there a way to have a macro or a way that those comment always stay same spot, next to where they where create? Follow the box no matter what the filter it?
Thanks