Hi,
I am having two sheets which contains Repcode and Preferred status.
I want to select Preferred status from sheet1 to sheet2

Example:
List of All Repcode
sheet 1:
A1 B1
Repcode Preferred Status
123 0
124 1
125 1
126 1
127 0

I want to select Record only if Preferred status is 1
in Sheet-2

A1 B1
124 1
125 1
126 1

any one can tell how to select these values using VBA Code(Macro).Because i am a dotnet developer and newer to VBA Programming.Please send correct code for selecting.

-Saravanan