import data between worksheets
 

If I have 5 worksheets in a file and want to have the data in cell C5 of one
sheet displayed in a cell in another worksheet how do I get this done?
--
Thank you

import data between worksheets
 

Select the "sending" cell
Edit|copy
Select the "receiving" cell
edit|paste special|paste link

You'll see a formula that looks like:
=Sheet2!$C$5
If that sending cell is empty, you'll see the formula returns a 0.

You may want:
=if(Sheet2!$C$5="","",Sheet2!$C$5)
to hide the 0.

Kurt MN wrote:

If I have 5 worksheets in a file and want to have the data in cell C5 of one
sheet displayed in a cell in another worksheet how do I get this done?
--
Thank you

--

Dave Peterson