Copying data between Workbooks
 

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