What to use - VB?

G

Guest

I have worksheet with foods with many nutrients. Another worksheet has days
of week, meals are entered and the nutrients of each meal are totaled for the
day and week. Using formulas with the Lookup functions is alot of work and
this would be easier if the foods were treated as objects. I've never used
VBA, would it help here?
 
A

Anne Troy

Quite honestly, this sounds more like an application for a database than for
Excel. Have you considered using Access? It does more intuitively what Excel
requires VBA to do.
*******************
~Anne Troy

www.OfficeArticles.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top