Replacing cell value with comments...

[skonduru]

Hi all,

I have a range of data created by other user, i have to go through each cell value and add comment which i did manually in the review process. Is there a way to automatically replace the existing cell value with the comments made by me.

Any help will be highly appreciated.

Regards,

Sathish.

[Leith Ross]

Hello skonduru,

Provided your data is in a single column and the comments are also in that same column then this macro should do want you require. You can change the worksheet name and starting cell to what you need. They are in bold in the text below.

Please Login or Register  to view this content.

[skonduru]

Thanks for the quick reply Ross,

Can I set the range as Range("A2:M40") and skip directly to for loop.

Regards,

Sathish.

[skonduru]

Awesome, thats working great, but I am getting the author name into the cell too. How can I get rid of the author name within the replaced cells.

Regards,

Sathish.

[Leith Ross]

Hello skonduru,

Here is the amended macro. This will remove the author.

Please Login or Register  to view this content.