I would like to get the following macro expanded:
If somebody enters '03-014-00-01' in any of the cells of the range spanning from B2:B80 on the Worksheet 'Offer', ...
... the following macro is to be triggered
Dim wS3 As Worksheet
Dim rCnt As Long, cCnt As Long
Application.ScreenUpdating = False
Set wS3 = Worksheets("Offer")
Application.Range("Set_OMF_Basic").Copy Destination:=Cells(ActiveCell.Row + 1, 1)
Application.CutCopyMode = False
Application.ScreenUpdating = True
Professional Help is very much appreciated. I have attached the corresponding file for your convenience.
Thank you very much in advance.