Copy & condition

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hello to all,
I have different ranges of cells in sheet1 as follows:
B14:G58
N14:O58
Q14:R58
I need to have a way so as to copy these ranges to sheet3 at the same cell
addresses respectively. I.e. to be copy to:
B14:G58
N14:O58
Q14:R58
at sheet3 in a way that contents of sheet3 are automatically updated when
changes in a cells in sheet1 is changed.
i.e. if I typed "Nicolas" in B14 in sheet1 the same value "Nicolas" will
appear at sheet3 in the same location at cell B14.

Any Help is appreciated.

Khalil
 
Go to B14 on Sheet3 and type =Sheet1!B14
Now copy and paste that formula to all of the ranges you have specified.
Each of those cells on Sheet3 will be updated in real time whenever the
equivalent cell on Sheet1 is changed.
- KC
 
Thank you very much it worked well.

What I see is that when a cell in sheet1 is empty (no values) the result in
sheet3 will be zero.
Can I avoide this and have an empty cell with nothing inside?

Another thing is that colomn G is representing a year.
How can I see the value of 00 if the year is 2000 and the value is entered
as 00 instad of 2000.

Hope to get help
thanks
 
If I may add a couple things. With the links in Sheet 3, the user must not
change the cells in Sheet 3. that will destroy the link. It's not a
two-way link.

To prevent the zeroes, you can use -IF(Sheet1!B14<>"", Sheet1!B14, "") You
can use the Fill Handle to copy this into the other cells, both downward and
across.
 
To have dates show the way you want, select that range in column G and go to
Format->Cells...on the "Numbers" tab, choose "Date" from the list, and then
a bunch of available date formats show up in a new list that you can pick
from. Select one that shows the year as 2 digits.
 
thanks for the note, but what i ment is I only enter the year in that cell .
example:
i type 06 or 2006 only and not a whole date; I am using only the year part.

Khalil
 
Thank a lot it works well.
Khalil

Earl Kiosterud said:
If I may add a couple things. With the links in Sheet 3, the user must
not change the cells in Sheet 3. that will destroy the link. It's not a
two-way link.

To prevent the zeroes, you can use -IF(Sheet1!B14<>"", Sheet1!B14, "")
You can use the Fill Handle to copy this into the other cells, both
downward and across.
Click to expand...
 
Solved!
thanks

Khalil Handal said:
thanks for the note, but what i ment is I only enter the year in that cell
.
example:
i type 06 or 2006 only and not a whole date; I am using only the year
part.

Khalil
Click to expand...
 
Back
Top