dont need a macro , in col 5 put

=IF(OR(A1=1,A1=4,A1=8),"I want","")

paste it down all of col 5

Rich


"tbobo" wrote:


Col-1 Col-2 Col-3 Col-4
1 6 a b
1 6 a b
1 5 a b
2 7 a b
3 3 a b
3 9 a b
4 6 a b
4 4 a b
4 3 a b
5 3 a b
6 8 a b
7 8 a b
8 8 a b
8 8 a b
9 4 a b
9 4 a b
10 4 a b

I am interested to create a macro that we allow me to retrieve the data
1,4,and 8 from Col-1 and add the fifth Col with with "I want". My ouput
result should be :

Col-1 Col-2 Col-3 Col-4 Col-5
1 6 a b I want
1 6 a b I want
1 5 a b I want
4 6 a b I want
4 4 a b I want
4 3 a b I want
8 8 a b I want
8 8 a b I want


My data file contains hundred of lines. I need to retrive data by
user-define in this case it is 1,4,8!

Many thanks!


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=519777