The Data Form helps.. for other people entering the information.

I would love to be able to use Crystal Reports to create my own thing; But I
don't know the first thing to it.

I appreciate your time. I am going to keep this spreadsheet simple. It does
what I need it to do. I always have a habit of making things better, but I'm
done. It's over, and it works. Always the best part.

Thanks again,
Jeremy

"Kooster" wrote:

It sounds like you set this up like a relational database, i.e., multiple
tables (sheets). Excel works as a flat-file database (one file/table,
multiple fields and records). You can use lookup functions on Excel to help
with data entry, e.g., salesperson number produces name in another column.
You can use the data form to produce a data entry screen in field order.

You can produce an area in the spreadsheet to summarize data and act on it.
Look this over:
http://office.microsoft.com/en-us/as...186941033.aspx

Personally, I would use Crystal Reports (has a better report writer), or
Excel using Microsoft Query. Look he
http://office.microsoft.com/en-us/as...864661033.aspx

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