Formula question-Can you create a formula to pull from one worksheet to another?

Can you create a formula to pull from one worksheet to another, both within
the same file?

Yes, a simple example

=Sheet2!A1

in other words just preced the cell ref with the sheet name and !. If the
sheet has embedded spaces, enclose in single quotes, such as

='This Sheet'!A1

--
HTH

Bob Phillips

"Jeffrey" <[email protected]> wrote in message
news:[email protected]...
> Can you create a formula to pull from one worksheet to another, both
within
> the same file?

Jeffrey,

Use a simple formula like the following:

='Sheet2'!A1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Jeffrey" <[email protected]> wrote in message
news:[email protected]...
> Can you create a formula to pull from one worksheet to another,
> both within
> the same file?