Im brain dead. How do you use the following correctly so if range B1 on sheet 1 = "Y", then put the value of sheet1 range A160 in sheet 2 range E6?
[vba]Select Case Sheets("Sheet1").Range("B1")
Case "Y"
Sheets("Sheet2").Range("E6") = sheets("Sheet1").Range("A160")
End Select[/vba]