jzamilpa3
05-21-2008, 05:10 AM
is it possible to insert a comment box and copy and paste wording into
it from 2 diffrent columns on another sheet. the thing is that i have
a countif in sheet3 columnB for the wording in columnA. the wording in
columnA is looked for in sheet2 that will provide how many times is
found. also there is wording next to the colunm the countif is looking
at and i need or wanted to insert a commentbox with the wording from
sheet2 into columnB of sheet3.
it should something like this
sheet 1
A B
bl a
asd a
fsd a
fs a
f b
sd c
fs c
sheet2
A B
a comment box of all a's
b comment box of all b's and so on
c
d
it from 2 diffrent columns on another sheet. the thing is that i have
a countif in sheet3 columnB for the wording in columnA. the wording in
columnA is looked for in sheet2 that will provide how many times is
found. also there is wording next to the colunm the countif is looking
at and i need or wanted to insert a commentbox with the wording from
sheet2 into columnB of sheet3.
it should something like this
sheet 1
A B
bl a
asd a
fsd a
fs a
f b
sd c
fs c
sheet2
A B
a comment box of all a's
b comment box of all b's and so on
c
d