| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a row depending on the content of a cell in the row | Excel Worksheet Functions | |||
| How to insert rows that copy cell content of the row above | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Copy row based on cell content | New Users to Excel | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Linear Mode
