I have either a H or A in cell B5.

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I have either a H or A in cell B5.
If B5 is A I need the values in B6,B7,B8
to be in R6,R7,R8.
If B5 is H I need the values in B6,B7,B8
to be in T6,T7,T8.
Any help with a formula much appreciated.
Thanks Skip
 
Formulas can't move values from one cell to another. They can only "put" stuff
into the cell that contains the formula.

So maybe you could use a formula like this in R6:
=if(b5="A",b6,"")

If b5 is equal to A, then show what's in B6. Otherwise, return an empty string
(make the cell look empty).

You'd have to use similar formulas for each cell (R6:R8 and T6:T8).
 
Formulas can't move values from one cell to another.  They can only "put" stuff
into the cell that contains the formula.

So maybe you could use a formula like this in R6:
=if(b5="A",b6,"")

If b5 is equal to A, then show what's in B6.  Otherwise, return an empty string
(make the cell look empty).

You'd have to use similar formulas for each cell (R6:R8 and T6:T8).
Click to expand...

Another approach. Right click the sheet tab>view code>insert this.
Test by an entry in b5

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or _
Target.Address <> Range("b5").Address Then Exit Sub
Select Case UCase(Target)
Case "A": dc = "r"
Case "H": dc = "t"
Case Else: Exit Sub
End Select
Cells(6, dc).Resize(3).Value = Cells(6, "b").Resize(3).Value
End Sub
 
Back
Top