I am new to Excel and am assisting someone in doing this task.

User either enter a value or choose it from a drop-down list (Site 1 Name).
With this value, access another
Excel spread sheet to find this value then populate the previous Excel
spreadsheet with
values from the various columns.

For example, user will select HDO094, on the destination spreadsheet. The
marcro will go to the
source spreadsheet locate HDO094 then update the destination spreadsheet with
the Latitude and
Antenna Height information.

Example of the source spreadsheet (second).

Site 1 Site 1 Site1
Name Latitude Antenna Height
HDO094 18.38.57.20:N 42

I appreciate any help with this.

I don't think you need VBA. As long as both books are open "VLOOKUP"
should work
A2 = SearchText
B2 = =VLOOKUP($A$2,[SourceBook]Sheet1!$A$2:$C$40,2)
C3 = =VLOOKUP($A$2,[SourceBook]Sheet1!$A$2:$C$40,3)
HTH

Die_Another_Day
marg wrote:
I am new to Excel and am assisting someone in doing this task.

User either enter a value or choose it from a drop-down list (Site 1 Name).
With this value, access another
Excel spread sheet to find this value then populate the previous Excel
spreadsheet with
values from the various columns.

For example, user will select HDO094, on the destination spreadsheet. The
marcro will go to the
source spreadsheet locate HDO094 then update the destination spreadsheet with
the Latitude and
Antenna Height information.

Example of the source spreadsheet (second).

Site 1 Site 1 Site1
Name Latitude Antenna Height
HDO094 18.38.57.20:N 42

I appreciate any help with this.