The html tag to format data in this forum is pre and /pre not prev and /prev. I assumed you noticed that your post was not formatted correctly. Is there a reason that you didn't fix it?
re: Whenever I select a company name from the drop down menu in Sheet2!D2 columns A, B, and C in Sheet2 are not populated so the macro does not appear to be firing.
The fact that "FGH, Inc." is being removed means that the macro is indeed firing. Read on...
re: ...the drop down in Sheet2!D2 is made up of a list in Sheet2!E: and Any idea how to keep "FGH, Inc." from disappearing?
I specifically warned you about that issue in my original response.
I'll repeat what I said:
Note: You didn't say whether you had any other data in the sheets other than in Columns A:C so, as written, the code copies and pastes the entire row from Sheet 1 to Sheet 2. If this is going to copy data from Sheet 1 that you don't want, or overwrite data in Sheet2 that it shouldn't, then you'll need to limit the range that gets copied/pasted.
In your original post you said:
"Any help to get me off the ground with VBA would be great!"
I assumed that you meant that if you were given some code as an example, you could modify it so that it worked for your specific needs. So I "got you off the ground" and warned you about the fact that the code copy/pastes the entire row and would overwrite any data beyond Columns A, B and C.
I guess I shouldn't have assumed that you would know how to fix that. My error.
re: The drop down list is now in Sheet2!D2
...and that is the major source of all of your issues.
The code was written based on your original specifications:
In spreadhseet 2, cell D1 I have a de-duplicated drop down list
Moving the Drop Down to another location requires more modifications to the code than just changing the Target.Address. Since the code clears data from Row 2 down, as well as copying and pasting entire rows, it was wiping out not only parts of your Drop Down source list, but the Target data itself since it was in Row 2.
I have attempted to modify the code to work with what I think is your current situation. It now looks for a change in Sheet2!D2, only clears Sheet2!A:C only Copy/Pastes from Sheet1!A:C.
If you can get this to work, come back and let me know. I have some troubleshooting techniques that I think you should learne, but I don't want to add any more complexity at this point.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim last_1Rw, last_2Rw, nxt_1Rw, nxt_2Rw As Integer
'Check to see if a change was made to the Drop Down cell
If Target.Address = "$D$2" Then
'Disable events so the code doesn't fire when the chagesa re made
Application.EnableEvents = False
'Determine last Row of data in Sheet 2 and clear data
last_2Rw = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row + 1
Range("A2:C" & last_2Rw).ClearContents
'Determine last Row of data in Sheet 1
last_1Rw = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
'Initialize Row counter for Sheet 2
nxt_2Rw = 2
'Loop through Rows in Sheet 1, Column A
For nxt_1Rw = 2 To last_1Rw
'If the contents match the Drop Down cell, copy data
'in Sheet1!A:C to the next open Row in Sheet 2
If Sheets(1).Cells(nxt_1Rw, 1) = Target Then
Sheets(1).Range("A" & nxt_1Rw & ":C" & nxt_1Rw).Copy _
'Increment Row counter for Sheet 2
nxt_2Rw = nxt_2Rw + 1
Application.EnableEvents = True
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.