How can I copy the contents in two cells onto other two cells if another cell is true?
Of instance, in the following example I'm copying the content from D3 onto F3 if B3 is TRUE. What I would like to be able to do is copy the contents of D3 and E3 onto F3 and G3 if B3 is TRUE.
I tried the following but it doesn't work.
IF(B3=TRUE, Range("D3:E3").Copy Range("F3:G3"), "")
Again, how can I copy the contents of two cell onto other two cell if a certain cell is true?
CodePudding user response:
If one has Office 365 put this in F3:
=IF(B3,D3:E3,"")
and the results will spill over to the next cell.
If one does not have office 365 then each cell will need a formula:
Put this in F3:
=IF($B3,D3,"")
And drag it over one column into G3.