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


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