import data between worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top