|I attacked this problem in a different manner, without using VLOOKUP or Copy/Paste.|
Instead, I used the Advanced Filter feature and created a macro to accept user input as the Criteria.
I started with the example shown at this site:
After setting up Sheet 1 with the List Range (A5:D19) and the Criteria Range (A1:D2) as shown in that example, I then wrote the following code to present InputBoxes to the user, asking for the Country and Qtr.
Once the user enters the criteria, those values are stored in the Criteria Range on Sheet 1 and the code produces a Filtered list on Sheet 2.
At this point it's pretty basic, but I think it shows what can be done once more detailed is supplied.
'Clear Sheet 2
'Get Country from user
myCountry = Application.InputBox("Enter Country")
'Store Country In Sheet 1 Criteria Range
Sheets(1).Range("C2") = myCountry
'Get Qtr from user
myQtr = Application.InputBox("Enter Qtr")
'Store Qtr In Sheet 1 Criteria Range
Sheets(1).Range("D2") = "Qtr " & myQtr
'Produce Filtered Results
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03