I want to create a macro that will read in a range of cells (ex: i2 -
as2)
and then look at each value in the cells. If that value matches a
certain
value I would like it to print out a certain phrase. But if it doesn't
then I
would like it to not do anything and just move on until it finds the
equal
value. Look through a row to find a value and for each case found,
print out
a phrase in column.

Example:
If you have table,
...x y z
a 1 1 1
b 0 0 1
c 1 1 0

abc are names while xyz and certain topics. if a has a 1 value for any
of
the xyz i want it to print out something like:
a.....x
.......y
.......z

b.....z

c.....x
.......y

If I'm not making clear just let me know and I'll try to clarify. Also

remember that I'm new to macros so I might need some additional
guidance.


--
asianmike
------------------------------------------------------------------------
asianmike's Profile: http://www.excelforum.com/member.php...o&userid=30973
View this thread: http://www.excelforum.com/showthread...hreadid=507654