Hello.

I have various reports in one folder and am looking to pull any rows that have a "Local(variable number from 0-99)" in column A from any of the files into one master file. They are all located in My documents/Produce. Hopefully this VBA/Macro could also prevent duplicates based on a unique code in column B. Any help is greatly appreciated.

Thanks!