Thread: If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GTVT06 GTVT06 is offline
external usenet poster
  
Posts: 141
Default If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
This worked for me... I just tested it on row 1, but it can be
adjusted for your needs

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("A1").Value = Range("B1").Value Then Range("D1").Copy
Range("E1")

End Sub
Reply With QuoteReply With Quote