=A1
Reference the same sheet

=Sheet1!A1
reference the same cell in a different sheet

=[book1]Sheet1!A1
reference a cell in a unsaved workbook

=[book1.xls]Sheet1!A1
reference a cell in a saved workbook

--
If this post helps click Yes
---------------
Jacob Skaria


"Beautiful" wrote:

how can a formula reference data containd in several sheets or books?