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
Bookmarks