Formula question
 

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" wrote in message
...
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" wrote in message
...
Can you create a formula to pull from one worksheet to another,
both within
the same file?