Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you connect worksheets,input data in one place&it shows on | Excel Worksheet Functions | |||
How do I connect two worksheets together? | Excel Discussion (Misc queries) | |||
How to connect to database? | Excel Worksheet Functions | |||
Formula to connect cells in different worksheets? | New Users to Excel | |||
Help! I need to create worksheets to connect? | Excel Worksheet Functions |