Worksheet Change to copy from a sheet based on values from data validation list

Hello!

I have some code that populates a range of cells with a range from another sheet based off what is chosen from a data validation list. I am running into a couple of issues when attempting to append to the existing data.

Example:

G4 has a data validation list and when someone chooses an item from that list cells H4:J30 get populated with values from cells B2:E30 from a corresponding sheet
ie: I choose "Client Services" from the "Billing" sheet in cell G4. Information from the "Client Services" sheet gets populated into the "Billing" sheet.

G5 also has a data validation list and when someone chooses an item from that list it REPLACES the values that are already populated from the G4 macro.


Is there a way to have the values from the G5 item populate in the next available row?

Here is what I have so far:

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Range("G4:G30"), Target) Is Nothing Then Exit Sub

Application.ScreenUpdating = False
Worksheets("Billing Form").Range("H4:J30").Value = Sheets(Target.Value).Range("B2:E30").Value
Application.ScreenUpdating = True

End Sub

Thanks!

It would be easier for someone to help you if you uploaded a sample workbook.

Sorry having difficulty uploading.