Creating Macro to copy information from cell into another cell using Add Comments

P

pmipalma

Hi,

I want to create a macro that will pick up a range of cells aa19:aa95
In these cells there is a formula
=IF($E19="YES",VLOOKUP($C19,'Brand Detail'!$A$1:$P$5000,AA$6,FALSE),"")
for example

I want to add comments transfering the information (TEXT) to column
(G)

How should the macro coding look like to do this?

Many thkx for your answer
Steven
 
G

Guest

Sub BBB()
For Each cell In Range("I1:I3")
Cells(cell.Row, "G").NoteText Text:=cell.Text
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding formatting rules for Comments in Macro 2
Add row dynamically 15
Macro to copy into Comments pop-up 1
Copy cell backgound color to another cell 1
copy range using last active cell reference from 1 wkb to another 1
creating a macro to add text to existing data already in cell 6
Creating a macro to paste in a specific cell 4
Help creating a macro to copy from one cell to another spreadsheet 1

Top