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?

=if(iserror(vlookup(a2,data!A1:b1000,2,0),"",(vloo kup(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:

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?

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





On Dec 26, 1:37*pm, Marcelo wrote:
=if(iserror(vlookup(a2,data!A1:b1000,2,0),"",(vloo kup(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:



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?- Hide quoted text -

- Show quoted text -

"rpick60" wrote:
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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---