Copy from one named cell to another dependent on content of a third.
 

HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.

Copy from one named cell to another dependent on content of a thir
 

If only numbers appear in column H try =IF(B1=1,H1,0) in cell K1 then copy down
This will cause a zero to appear in column K where number in column B is not 1
If you do not want a zero to show go to TOOLS, OPTIONS, VIEW and untick Zero
values.
Alternatively if you are entering letters or other symbols in column H you
could try =IF(B1=1,H1,"") in cell K1 and copy down. Hope this helps.



"Colin Hayes" wrote:


HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.

Copy from one named cell to another dependent on content of a thir
 

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

In K1, copied down: =IF(H1=1,B1,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Copy from one named cell to another dependent on content of a thir
 

In article , Ron@Buy
writes
If only numbers appear in column H try =IF(B1=1,H1,0) in cell K1 then copy down
This will cause a zero to appear in column K where number in column B is not 1
If you do not want a zero to show go to TOOLS, OPTIONS, VIEW and untick Zero
values.
Alternatively if you are entering letters or other symbols in column H you
could try =IF(B1=1,H1,"") in cell K1 and copy down. Hope this helps.

Hi Ron

OK thanks for that - very helpful

I was wondering if this could be extended to include the existing
content of K1 , rather than over write it.

So , that in L1 we could have code which would say that

If H1 is 1 , then the content of B1 should be copied into L1

but

If H1 is 3 , then the content of K1 should be copied into L1.


Is this possible?

Thanks again.




"Colin Hayes" wrote:


HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.