I have a range of data on one sheet and I want to reference this range to another sheet so that I can work on these data but on a separate sheet, Like in the next screenshots:
[This is the original Data Range]
[This is the data using the filter function on another sheet and I added comments to them]
So far this works okay but if I sorted the original data range, the comments will not be linked to the correct data, like in the screenshots below:
[Here I sorted the original range from Z-A]
[You can see that the comments didn't follow the correct range]
I realize that maybe using the filter function isn't the best way to do this but I couldn't find another way to duplicate the range on multiple sheets