1
I have a report on Excel that built using database query. I need to write comments on each row. When I refresh the file the comments don't stay on the same row and don't match the record. What should I do to make it work?
Natella
Posted 2016-02-10T14:41:03.077
Reputation: 11
1
Unfortunately there is no easy way for that.
Best workaround I came up until now is to copy unique columns to a new sheet (I hope you have them) and enter comments there. Then use VLOOKUP to populate comments in the original sheet.
Máté Juhász
Posted 2016-02-10T14:41:03.077
Reputation: 16 807