PDA

View Full Version : How to call value from one sheet to another sheet using VBA macro



saravanan.p
05-28-2010, 07:02 AM
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