macro to find and enter
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 |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com