| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Macro to copy information from cell into another cell using Add Comments
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Macro to copy information from cell into another cell usi
Sub BBB()
For Each cell In Range("I1:I3") Cells(cell.Row, "G").NoteText Text:=cell.Text Next End Sub -- Regards, Tom Ogilvy "pmipalma" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Macro to copy information from cell into another cell usi
Perfect Many thanks
You made my day Works perfectly Tom Ogilvy schreef: Sub BBB() For Each cell In Range("I1:I3") Cells(cell.Row, "G").NoteText Text:=cell.Text Next End Sub -- Regards, Tom Ogilvy "pmipalma" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If blank cell, copy information from cell above | Excel Worksheet Functions | |||
| creating a formula that condenses information in a cell | Excel Worksheet Functions | |||
| Creating fixed information in a cell | Excel Discussion (Misc queries) | |||
| Help creating a macro to copy from one cell to another spreadsheet | Excel Programming | |||
| Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
Linear Mode
