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.

--
Message posted from http://www.ExcelForum.com