I HAVE THIS COD THAT COPIES OVER THE DATA FROM THREE CELLS IF ANY DATA IS ENTERED IN COLUMN T
BUT I WANT TO COPY IT OVER TO A SPECIFIC WORKSHEET ONLY IF THE DATA IS SPECIFIC
FOR EXAMPLE IF I ENTER "JM" IN COLUMN T I WANT THE DATA FROM COLUMN A,B AND G TO COPY OVER TO WORKSHEET "JM"
IF I ENTER YH IN COLUMN T I WANT TO THE DATA FROM COLUMN A,B AND G TO COPY OVER TO WORKSHEET "YH"
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A5,B5,G5").Select
Range("G5").Activate
Selection.Copy
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets("1").Select
Range("A2").Select
ActiveSheet.Paste
End Sub
PLEASE HELP
Bookmarks