ExcelBanter - how do i work across workbooks in excel 2002?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i work across workbooks in excel 2002? (https://www.excelbanter.com/excel-discussion-misc-queries/2955-how-do-i-work-across-workbooks-excel-2002-a.html)

lesgold80

how do i work across workbooks in excel 2002?

I am trying to develop an application that requires me to sum values across
workbooks. Is this possible to do in Excel 2002 and how is it performed?

Peo Sjoblom

Open up the workbooks in question, type =SUM(
click window in the menu and select the first workbook and the cell(s),
type in a comma and repeat and select the next workbook

Regards,

Peo Sjoblom

"lesgold80" wrote:

I am trying to develop an application that requires me to sum values across
workbooks. Is this possible to do in Excel 2002 and how is it performed?

All times are GMT +1. The time now is 10:41 PM.