When you say require a macro would you be able to tell me how to do that? I
understand the VLOOKUP formula part of it.

"kassie" wrote:

The first part of your problem would require a macro. Alternatively, you can
use a prompt which comes up if you do not have the relevant customer's
details in your database, telling you to enter this detail n your database
first. You would use a VLOOKUP formula, combined with ISNA, to do this.
The second part would in any case require the use of a VLOOKUP formula. I
have set up a quotation input form utilising this strategy, if you are
interested.
--
Hth

Kassie Kasselman
Change xxx to hotmail


"ChrisLouie" wrote:

I have a form created in Excel. Is it possible to set it up in a way that
when I enter Customer Info (name, company, address, phone#) that it is
automatically saved in another spreadsheet. So that when I enter that name
again in the future the address, company and phone # automatically populates?