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!