I have a Macro that when a dropdown box is presented you select a choice. It then pulls a Column of data into a worksheet (Destination) from another worksheet (Source) which I'm using as a Flat File DB. I have the Data that's pulled into the Destination File listed in named ranges that are listed in the drop down box. Here's my challenge. I need to add a column of data in the DB that then populates the Destination Worksheet. How do I pull information from the DB that has contiguous columns, into the destination worksheet into the target column (A) and then into a column that is three columns to the right (E). So for example, in the destination worksheet, data from the source DB Worksheet is populated into Columns A and E. However, in the source DB, the Columns of data are in A and B. Data in A (Source) goes to column A in Destination. Data in B (Source) goes to column E in Destination.
Here is the code I'm presently using in the Worksheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$N$17" Then
Worksheets("Question_DB").Range(Replace(Target.Value, " ", "_")).Copy Worksheets("Questionaire").Range("A2")
Thank you in advance.