VBA condition rules based on drop down list

[alphabetagamma]

Hi Guy's

I am very new to VBA and i am struggling with a code based on the option which are selected from the drop-down list.

Drop down list is in column D in the sheet "MyData". Columns A-C will be populated with data. What I want to do is: if option "Terminate" or "End" are chosen from the drop-down list in column D, macro will switch/open sheet "Terms" and automatically copy data from that row in "MyData" columns A-C which are in the same order in "Terms".


Is there a simple way to do this?

 

[My Aswer Is This]

I'm assuming you want the range in Sheets("MyData") copied into the same exact row in Sheet("Terms")
That's the way I understand your posting.

Put this script in sheet named "MyData"

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab Named "MyData"
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D:D")) Is Nothing Then
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
Dim ans As String
Dim r As Long
r = Target.Row
ans = Target.Value
If ans = "Terminate" Or ans = "End" Then Range(Cells(r, 1), Cells(r, 3)).Copy Sheets("Terms").Range("A" & r)
End If
End Sub