So I have a cell that has the following formula,
=CONCATENATE(G4,H4,I4,J4,K4,L4)
This reads [TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"],IF("Butter"=$C$2,C45)
Now I want to copy that and add it to a cell that already has a bunch of similar statements
Currently it looks like this =IF($C$2="Cheese",C17,IF($C$2="Bioethanol",C31[inser new data here]))
But when I copy it puts the moving dotted lines around my Concatenate then when I select the cell to insert the moving dotted lines disappear leaving me very frustrated...
This should be a simple request, why MUST the copy only be available when the cell is selected... why not have something like word document, when I copy my name at the front of the document it doesn't highlight the word only to be lost as soon as I highlight something else. Is there a reason for this stupidly complex copy paste system in excel? Can I get around it?[/TD]
[/TR]
</tbody>[/TABLE]
=CONCATENATE(G4,H4,I4,J4,K4,L4)
This reads [TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"],IF("Butter"=$C$2,C45)
Now I want to copy that and add it to a cell that already has a bunch of similar statements
Currently it looks like this =IF($C$2="Cheese",C17,IF($C$2="Bioethanol",C31[inser new data here]))
But when I copy it puts the moving dotted lines around my Concatenate then when I select the cell to insert the moving dotted lines disappear leaving me very frustrated...
This should be a simple request, why MUST the copy only be available when the cell is selected... why not have something like word document, when I copy my name at the front of the document it doesn't highlight the word only to be lost as soon as I highlight something else. Is there a reason for this stupidly complex copy paste system in excel? Can I get around it?[/TD]
[/TR]
</tbody>[/TABLE]
