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
>
>