Excel VBA auto entry of data

G

gelo_d

ei does anyone knows how to do this..here's the exmaple

WORKSHEET1

A B C
D
1 SSN Last Name First Name Rate
2 525-23-2222 SMITHS ALEX 32
3 424-22-3344 LANE JAMIE 20


WORKSHEET2

A B C D
E
1 Last Name First Name SSN Rate Hour
2


NOTE: what i want to happen is that once i enter the SSN data i
worksheet2 the Last Name, First Name and the Rate will also appear i
worksheet2 its like an auto entry....i only want to enter the SSN s
that i wont keep typing of the names and the other data.. is there
code or formula for this? please help me so....tnx a lot.
 
T

Tom Ogilvy

for last name

=if($c2<>"",Vlookup($C2,Worksheet1!$A$2:$D$3,2,False),"")

for first name

=if($c2<>"",Vlookup($C2,Worksheet1!$A$2:$D$3,3,False),"")

for rate
=if($c2<>"",Vlookup($C2,Worksheet1!$A$2:$D$3,4,False),"")
 
Top