I would be able to, yes, but I would need much more detailed info to do that.
I again suggest you look at my quote input form. The problem is that if you
go the macro route, you will be overwriting your formulae, although the macro
can replace those.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"ChrisLouie" wrote:

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?