Hi all,
I have 3 tabs in an excel sheet with same format and headers in a table form, from where I am pulling the data through appending query and putting it in a new tab with some filters to see only filtered data.
I want to add a new column on the right most side in this newly made table to write any comments, which I did.
Now when I update the table after I changed something in one of the first 5 tabs, of course the query table will get updated but the comments section in newly added column remains static, which means they stay in the same cell where i have put them. Is there a way the comments cell remains attached to the row where the comment was put in the first time, being dynamic?
Thanks in advance.
Bookmarks