I have been struggling with an Excel problem that is driving me carzy. I am
trying to design a PO request form (called Form) where I have a list of 12
buildings on another sheet (called Data) in column A. The list works great.
What I am trying to do is bring up the list on the Form sheet, click the
building name to bring up the number of the building in column B. I'm sorry
if this is hard to understand but I want to bring up the list on the Form
sheet choose the building and the building number appears in the cell.
Thanks, can anyone help?