I wouldn't use a VBA macro to do this, but simply a number of concatenated
vlookups that return the different fields of your database of branch
addresses. Then the user would type into a cell the branch number and the
vlookup cell would immediately dispay the branch name&address corresponding
to that number. The seed number can remain displayed, but if you don't want
it to be visible on the form then simply have that cell outside of the
PrintArea or have its font color's the same as the cell's background's color.
You may post this question on the "worksheet functions" discussion group, to
have better idea.
--
Stefano Gatto


"MEI" wrote:

I have the database setup in Excel for our branches but instead of typing in
each branch location address each time I provide a quotation, I would like to
be able to type in the branch number and have the branch location address and
branch manager name automatically be inserted on the quotation form I have
set up in Excel. I purchased a Macros program but it's above my head.