View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How do I connect 2 worksheets with a formula?

What do you mean by "connect"? If you mean that you want the value
from worksheet01 to appear in the same cell in worksheet02, then put
this formula in A1 of worksheet02:

=IF(worksheet01!A1="","",worksheet01!A1)

Hope this helps.

Pete

On Nov 19, 9:59*am, Daniel Ciciu <Daniel
wrote:
I've ceated an worksheet for a month, and I have to connect the day 01 with
the day 02 then with day 03 and so on, with a formula. For ex. I have to
connect the cell A1 from worksheet01 (day 01) with the cell A1 from the day
02 (worksheet02). Can anyone tell me the formula that I can use? Thanks!