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

"Anne Troy" wrote:

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/p...plications.htm


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

"MissouriRiceFarmer" wrote in
message ...
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.