How do I set up a template & database with Excel 2000/03?

[Guest]

I am a farmer who uses Excel to record large amounts of information. I have
a worksheet that I use to record crop types and yield information onto.
How/Can I create a template of this sheet(their will actually be several
copies in the workbook for all the different fields/farms and years) and have
certain info from each sheet recorded into a database that I can access when
needed, to view historical trends.

 

[Anne Troy]

That sounds like an application that would much better be built in Access.
Do you have Access?
You might want to read this article. While it's about VBA, the "Which
application to use" part might give you some insight:
http://www.officearticles.com/misc/purchasing_vba_programming_for_microsoft_office_applications.htm


************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

 

[Guest]

I do have Access, but I need Excel to run the calculations from all the
information I enter. Any thoughts? Thanks

 

[Anne Troy]

Access is more than capable of running any calculations you're performing in
Excel.
If you'd like to email me at my first name at the first website below my
name, I'll be more than happy to try to give you some guidance. I have also
been known to create quickie databases, too.
I truly think if you want to see history for multiple items and multiple
timeframes, you're going to be much better off with Access. Others here who
know how to program Excel may disagree, but I don't believe in programming
something that doesn't need to be. If you do send the files, please
remind me that you're the farmer.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com