Transferring a cell value to another sheet

[John]

Is it possible to input a formula to transfer a cell value from one sheet
to another within a spreadsheet
eg to make C7 in sheet 1 equal C7 in sheet 2 ?

 

[Nick Hodge]

John

Using a formula in Sheet1 C7

=Sheet2!C7

If you mean just make it magically appear without a formula, no, except with
some code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html