Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you Sparse a field in Excel??? and Database Query?? | Excel Discussion (Misc queries) | |||
Query Excel database from desktop | Excel Discussion (Misc queries) | |||
Set Database in Excel | Excel Discussion (Misc queries) | |||
Excel Database | Excel Discussion (Misc queries) | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) |