Macro To Browse Select File And Import Specific Data

[Charles]

Hi,

In this attachment you will see a button for test.
This will produce a Dialog box so you can select the file you want to retrieve the data from.
I used a filter in the code that will look for duplicates and only set the filter for the Item to be filtered.
The file you open must have a "Header" row else the code will not filter the data correctly.
It will copy the filtered range to the worksheet. In your example you have more data than the workbook you are copying from.
It's the last column in the attached workbook.
I hope this is close to what you want.