I'm a novice and could use your help. Sheet 1 column A contains a list of
identifying numbers, column b contains of list of names associated to those
identifying numbers, column c contains a list of addresses associated to
those numbers, column d contains a list of citys associated to those numbers
and column d contains a list of zip codes associated to those numbers. On
Sheet 2, when I enter an identifying number on any row in column e, I need a
macro that will find that same identifying number on Sheet 1 (along with
associated information by row) and enter all associated information on the
row where I originally entered the identifying number.

When finished, Sheet 1 column a = Sheet 2 column d, Sheet 1 column b = Sheet
2 column e, Sheet 1 column c = Sheet 2 column f, Sheet 1 column d=Sheet 2
column f, and Sheet 1 column e = Sheet 2 column g. Thanks for your insight.

Larry

Thanks Jim. I'll give it a shot.

"Jim Thomlinson" wrote:

You don't need a macro. You can use a Vlookup function similar to this

=vlookup(A2, Sheet1!$A$1:$D$1000, 2, false)

Look up the vlookup function in the help menu for more details.

--
HTH...

Jim Thomlinson


"Larry" wrote:

I'm a novice and could use your help. Sheet 1 column A contains a list of
identifying numbers, column b contains of list of names associated to those
identifying numbers, column c contains a list of addresses associated to
those numbers, column d contains a list of citys associated to those numbers
and column d contains a list of zip codes associated to those numbers. On
Sheet 2, when I enter an identifying number on any row in column e, I need a
macro that will find that same identifying number on Sheet 1 (along with
associated information by row) and enter all associated information on the
row where I originally entered the identifying number.

When finished, Sheet 1 column a = Sheet 2 column d, Sheet 1 column b = Sheet
2 column e, Sheet 1 column c = Sheet 2 column f, Sheet 1 column d=Sheet 2
column f, and Sheet 1 column e = Sheet 2 column g. Thanks for your insight.

Larry