I have two sheets, and I want to copy the comments for each cell of column B
in sheet 1 to column C
in sheet 2.
I dragged Ctrl, but just the values of each cell of Sheet 1, Column B
, were copied to Sheet 2, not the comments!
How can I copy the comments from each cell to Sheet 2?
I searched the internet but did not find an answer.