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
--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread:
http://www.excelforum.com/showthread...hreadid=485604