Forumla to Copy multiple Cells

[GreenyMcDuff]

Hi all,

I have the following data sheet:

Price A	Price B	Type 1	Date 1		Price C	Price D	Type 2	Date 2
					A	B	Trade	10/05/2011
					A	B	Trade	10/05/2011
					A	B	Bid	10/05/2011

I need a formula that works in the following way:

IF Type 2 = "Bid" Then
Copy Price C to Price A
Copy Price D to Price B
Copy Date 2 to Date 1

This is a formula that I came up with.... it does not do the trick

=IF(S1="Bid",(M1=Q1,N1=R1,P1=U1),"")

Thanks for your help

Chris

 

[JackDanIce]

Generally speaking a formula can only affect the cell you enter it into. I think you're looking for a macro solution

 

[JackDanIce]

Chris,

This macro may be what you want:

Sub KillAllTheHumans ()
 
Dim i as Long
 
Application.ScreenUpdating = False
 
For i = 1 to Range("S" & Rows.Count).End(xlUp).Row
 
  If Range("S" & i) = "Bid" Then
    Range("M" & i) = Range("Q" & i)
    Range("N" & i) = Range("R" & i)
    Range("P" & i) = Range("U" & i)
  End If
 
Next i
 
Application.ScreenUpdating = True
 
End Sub

 

[GreenyMcDuff]

Ok thanks for that JDI

Much appreciated

 

[JackDanIce]

Formula to Copy multiple Cells

You're welcome