by Michael O'Daly <mdodaly@[EMAIL PROTECTED]
>
Dec 20, 2005 at 04:11 PM
An easy method would be to use =sumif function and reference the other
sheet
or workbook.
On 12/3/05 4:39 PM, in article BFB77AD3.CC2E%larry@[EMAIL PROTECTED]
"Larry
Robinson" <larry@[EMAIL PROTECTED]
> wrote:
> 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!
>
