Okay folks... I'm an idiot. Here goes: is there a way to "automate" excel
in order to pull figures from one spreadsheet and place them onto another
spreadsheet. For instance, let's say I have worksheet entitled "list"
with
30 items listed in in column A - the item "banana" is listed 4 times in
column A. In column B there are numbers that correspond to each item in
column A.
On another worksheet I'll call "Totals", I would like to pull all of the
numbers associated with items from "list" in column A called "banana" and
total them.
I hope I am illustrating the example clearly. I could always take a
calculator and add up all of the numbers associated to the item "banana"
and
then enter that number on the other worksheet but I'm lazy. Also, every
month the "items" in column A change order and one month there are 30
items,
the next month there are 45 items.
I guess what I'm asking is, "does excel have a "find" function that can
total fields associated like words". Hmmmmmm... Any thoughts? Thanks!
