Copy cell to another as a comment

[rpick60]

I import external data and I would like to take text in a cell and add
it to another cell as a comment.
I have a long list of part numbers and some have sizes. I would like
to take the sizes and add them as comments to the part numbers. Not
all part numbers have sizes so I only want the ones with data in the
cell.

Any Ideas?

 

[Marcelo]

=if(iserror(vlookup(a2,data!A1:b1000,2,0),"",(vlookup(a2,data!A1:b1000,2,0))

assuming in a2 you have the code of the part, and on sheet data you have the
sizes and etc.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"rpick60" escreveu:

 

[rpick60]

Maybe I did not make it clear in column I i may have "Lifter" and
column J i would have "2 IN stroke"
I would like Column I to stay the same with a Comment of "2 IN Stroke"
I am actully creating lists and sorting them by part name or type. I
have that figured out already.
All of the cells in J are put in by designers and will vary all of the
time.
Thanks for the help

 

[Max]

in column I i may have "Lifter" and column J would have "2 IN stroke"
I would like Column I to stay the same with a Comment of "2 IN Stroke"

Think there's a Sub AddComments() at David McRitchie's page
which you could use:
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Scroll down about 1/3 on that page, look for:
Macro to populate comments in a range with text values of another range
(#addcomments)

---