Hi All, I'm running Excel97 on Win2K and need some advice.
I have a workbook with several worksheets (revenue
workbook). One of the worksheets gets filled in with user
data. One of the pieces of data is a store number. Another
workbook (store information) on the same machine has the
store information such as address, zip, phone, contact
info, etc. I need to get the information from the
information workbook to the revenue workbook upon entering
of the store number.

I.E. if someone enters store number 111, I want all of the
address and contact information taken from the information
workbook and populated in the revenue workbook.

Thanks