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?

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .