Hi all,

I have two workbooks. One is a balance sheet, and has a list of product #'s in column A, and a list of units corresponding to the product # in column B.

In the second workbook that I am creating, I have the same list of product #'s. I need to be able to input the sum of a group of units from workbook 1 into this new workbook, and have it be visible or 'saved' even when the first workbook is closed. For example:

If in workbook 2 I have product #'s 1, 2, 3, & 4, I need a way to pull the sum of the units from workbook 1 that have product #'s 1, 2, 3, & 4 into one cell in workbook 2, and have that cell in workbook 2 display the sum even if workbook 1 is not open.

Do I need to create a macro to do this, or is there a way to use a formula?

Thanks,