#1
|
|||
|
|||
Excel Help
How do I set up excel to record each weeks results (there are 5 metro meetings?)
I'm just collecting the information at this stage. Any thoughts to how I show lay out the spreadsheet. Benny |
#2
|
|||
|
|||
Quote:
Benny, it really depends on what you want to record and how you want to use the information. If for instance you want to run various queries on the data, then Excel is probably not the way to go as it can best be described as a flat-based database, which is not its primary function. A true relational database such as Access (not recommended) or FileMaker (highly recommended) or Lotus Approach (also highly recommended) would be the way to go for running queries etc. If OTOH all you want is a place to store information with allowance for some basic sort and query options then Excel is capable of doing this. If you can writ programs in VBA then Excel can give you added advantages, as can the use of macro's, but it really depends on what you are attempting to achieve. |
Thread Tools | Search this Thread |
Display Modes | |
|
|