Say I have 2 columns. Let's call them column1 and column2. Both columns cells contain some text or empty. What I want to do is to insert the text of a cell in column2 as comment to a cell on same row in column1 and apply it to all rows.

For example, given a table like this:

enter image description here

the cell with Text1 will have comment qith Text4:

enter image description here

and so on:

enter image description here

  • Close vote for being "too broad"? How is this too broad? It is a very specific question. – Eugene S Oct 19 '16 at 5:35
  • What have you already tried? – MJH Oct 19 '16 at 6:51
  • I tried to Google it but only found answers involving VBA which I'd like to avoid. – Eugene S Oct 19 '16 at 6:56
  • 1
    I think you're unlikely to find a solution for this that doesn't involve VBA. – MJH Oct 19 '16 at 6:59
  • Is there a reason you want to avoid VBA? I'm 99.32% positive you won't be able to accomplish this without it. – BruceWayne Oct 19 '16 at 14:14

Say we have data in A1 through B100. If you change your mind and would accept a macro-based solution, try this:

Sub CommentMaker()
    Dim A As Range, aa As Range

    Set A = Range("A1:A100")

    For Each aa In A
        aa.Comment.Text Text:=CStr(aa.Offset(0, 1).Value)
    Next aa
End Sub
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.