Sorry, auto complete for bldg name in sheet 2. For instance if you entered in
B2 of sheet 2, the letter "a" it would filter the bldg names list to only
those beginning with "a" etc. until you choose from a handful of bldg names.

Thx again!

"Ron Coderre" wrote:

AutoFilter/Autocomplete on which cells/sheet?

***********
Regards,
Ron

XL2003, WinXP


"James" wrote:

Got it...Thanks!...now is there any way for bldg name to auto complete or
auto filter?

"Ron Coderre" wrote:

Try something like this on Sheet2:

B2: (a bldg name)

The street
C2: =VLOOKUP($B2,Sheet1!$A:$E,2,0)

The city
D2: =VLOOKUP($B2,Sheet1!$A:$E,3,0)

etc

OR....
C2: =VLOOKUP($B2,Sheet1!$A:$E,COLUMNS($A2:B2),0)
copy C2 across to the right.....each successive cell will return more of the
address.

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"James" wrote:

Sheet 1 contains bldg name(column A), bldg street address(column B),
City(column C) etc.
Sheet 2 is a job/project log. I would like the user to type in only the bldg
name in column A and have the other columns auto populate in the respective
columns in sheet 2.
How can this be accomplished?

Thx!