Linking Worksheets

[marbie]

hey there,

how do i link work sheet 1 and worksheet 2 wherein everytime i type a data in worksheet 1 it will automatically be reflected in worksheet 2? thank you.

[vlady]

Hello Marbie
--Kabayan
Fastest way is to use Paste Special then choose pastelink - I think..

[vlady]

Select sheet 1 then
select the range you will use. CTRL + c
goto Worksheet2 then pastespecial.
youl notice that it will have a 0 value you can use conditions here to hide it.

[sandeep ghoman]

if you have a suggestion, if you have two sheets then "=Sheet1!A1" in Sheet2 and copy paste it in the same area you are going to use in Sheet1. It will automatically update the data.

[marbie]

thanks. I already used the "=Sheet1A1" function. however, i don't want 0 to appear in sheet 2 in case there is still no value in sheet 1. i was hoping that someone could help me wtih the formula so that no 0 will be copied / seen.

thank you.

[darkyam]

=IF(Sheet1!A1="","",Sheet1!A1) should do it.

[marbie]

it works!!! thanks a lot!!! =)))