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.
Hello Marbie
--Kabayan
Fastest way is to use Paste Special then choose pastelink - I think..
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
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.
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STAR
Dare to give a pencil to a child. http://www.blackpencilproject.org/
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.
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.
=IF(Sheet1!A1="","",Sheet1!A1) should do it.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
it works!!! thanks a lot!!! =)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks