Is this possible?

My manager asked me to perform a task in excel. I am not familiar with Macro programming.

What I need to do is have a macro that grabs information from TEST3 column and add it as comments to TEST 1 column.
I attached a screenshot to show what I need to accomplish.

I am running into 2 problems:

1st problem, notes A, B, C are in separate cells and when I try to combine them into one comment, I get "cells not of same range" error.

2nd problem is TEST1 rows are 1 cell, while TEST3 are multiple cells. Is there any way for a script to distinguish 1, 2, 3 as separate?

Originally Posted by abnorm

My manager asked me to perform a task in excel. I am not familiar with Macro programming.

What I need to do is have a macro that grabs information from TEST3 column and add it as comments to TEST 1 column.
I attached a screenshot to show what I need to accomplish.

I am running into 2 problems:

1st problem, notes A, B, C are in separate cells and when I try to combine them into one comment, I get "cells not of same range" error.

2nd problem is TEST1 rows are 1 cell, while TEST3 are multiple cells. Is there any way for a script to distinguish 1, 2, 3 as separate?

Hi,

to add the comment, in the cell type

=addcomment(C8:C11)

and in the Module (where Macros go) put the code

Please Login or Register  to view this content.

Let me know how you go
---

Thank you, that works! I am now one step further to accomplish what I need, but there is more.

1. I have to keep the current data in Clomn A (TEST1).
2. I need a script that runs automatically for every section (1,2,3,4,5,6) and adds data as comments from TEST3. (The actual document is very large)

Here is a better screenshot to show what I need to accomplish (preferable automatically):