Hi All,

Need your help.

I'm working on a spreadsheet ('Sheet1') that require a lot of comments for each cells, so rather than I do it manually by selecting every cells (Insert comment) I prefer to enter the comments in separate sheet (let's called it 'Sheet2) then run a macro to copy these comments and insert them as a comment to Sheet1.

For example:

Sheet1

A1 = 10
A2 = 11
A3 = blank
A4 = 15
.
.
.
B50 = 54
.
.
.
D39 = 17


Sheet2

A1 = Confirm with John if data is correct
A2 = Diane to action
A4 = Waiting for feedback
.
.
.
B50 = Met Target
.
.
.
D39 = Good

When Macro is run, then all comments from cell A1,A2 and A4, etc will be inserted as comment in sheet1 to the same cell.

Can anybody help?

Thanks in advance