Once you do this, chances are the data analysis will change, i.e., he'll want
more detail, better refinement, or new fields.

You would be better off in MS-Access. Take the time to plan the database,
the tables, and the data "normalization". You will be glad you did.

Plus, Access will have better reporting capability.

Question? It surprises me that these sales are not being entered somewhere
else, and that application should be capable of making these "reports". If
so, you can either put a 'hook' into that database with Excel, or a
third-party report writer, to get this done. This would eliminate the
requirement for Excel or Access. You can do the extraction of the data to
MS-Access, too.

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"JeremyH1982" wrote:

I was approached today by one of the VP's of the company I work for. He would
like to be able to enter information and then have the information sent to
where it needs to go.

For Example:

One person would enter

Salesman; Company Sold To; State; Pairs sold.

So Column A would be the salesman;
Column B would be the Company Sold To
Column C would be the State the company sold to is in
Column D would be the Amount of Pairs sold to the company.

Then after all that information is entered; He wants to be able to see the
percentage of the salesman's sales, in a given state.

So let's have it sort by the state; The salesman is assigned 6 states. I can
sort by the state, that's not a problem. I am just wondering if this would be
easiest in Excel or another program, access or something.

And If I do it in excel; I'm not very familiar w/ macro's. So if you may be
able to point me somewhere for Macro Knowledge; it would be appreciative.

Thank you.