ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I connect 2 worksheets with a formula? (https://www.excelbanter.com/excel-worksheet-functions/210875-how-do-i-connect-2-worksheets-formula.html)

Daniel Ciciu

How do I connect 2 worksheets with a formula?
 
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!

Pete_UK

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!




All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com