ExcelBanter - Excel Workbooks

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Workbooks (https://www.excelbanter.com/excel-worksheet-functions/184453-excel-workbooks.html)

darlylj

Excel Workbooks

I am trying to create a formula using references from another sheet within
the same workbook

Mike H

Excel Workbooks

a bit more detail would be useful but perhaps this which looks at sheet 2
from any other sheet and returns the value in a1

=Sheet2!A1

Mike

"darlylj" wrote:

I am trying to create a formula using references from another sheet within
the same workbook

Gord Dibben

Excel Workbooks

=SUM(Sheet1!A1:A23) entered in any cell in Sheet2

Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 08:03:00 -0700, darlylj
wrote:

I am trying to create a formula using references from another sheet within
the same workbook

All times are GMT +1. The time now is 09:34 PM.