Hi All,

Does anyone have any suggestions for the following:

Workbook 1 - Sheet3 has subtotals (Amount in Column G) by account (Column E).
Workbook 2 - Each sheet is named with an Account corresponding to Workbook 1.

I would like to take the subtotal in Workbook 1 and post the amount in the corresponding sheet in Workbook 2 Cell C5.

For example if the subtotal for account "A" in workbook 1 column G is $10, I would like that amount entered in Cell C5 Sheet A on workbook 2. Repeat for all other accounts.

Any help would be greatly appreciated!

Thanks