How do I connect 2 worksheets with a formula?

D

Daniel Ciciu

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!
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
copying_data_using_FillHandle 1
date mismatching 2
How to get largest date from a Vlookup 1
Unhide column difficulty 3
Date lists 3
Problem using IF statement with dates as part of the formula 4
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top