In a quick answer "Yes You Can".

Appreciate it.

Ok, if help need LMK

Is it basically adding to the existing code? Sorry still an amateur at this.

I want the userform to have ComboBox1, choose a year and it runs your macro as it does now. Ive added the years (2015, 2016, 2017, 2018) in column F of Sheet1.

HI,

It would be easier to see what can you send the workbook. I think sent you a PM sometime ago with my email address.

I've attached the workbooks. Thank you sir!

Attached Files

	Macro Data Test.xlsm (28.7 KB, 7 views)
	Vendor Template1.xltx (161.9 KB, 7 views)

Thanks will look it over

HI,

When you select the year you just want he selected year to populate the vendor file?

I would like the person to select the year and it populate just for the year chosen. Basically run like you have it, but just now for the specific year chosen in the userform.

Hi,

I modified the code.

Attached Files

Macro Data Test.xlsm (30.1 KB, 8 views)

Thank you.

When I run the code, it filters the first vendor for the correct year, but does not populate the Vendor Template1 sheet.

Hi,

The reason the data is not going to the Vendor file sheet is because the code you modified from "Sheet1, sheet2" to "Declaration , Product List". The template has sheet1 and sheet2.
If you change the sheet names to "Declaration , Product List". the code should work.

Thats right. Thanks for finding the error.

Ill edit that and test again.

Now its telling me the following error.

Complile Error:
Variable not defined

Its highlighting the following code.
For Each Item In NoDupes

***Update***
The code works fine when running by itself. I receive an error only by running the macro via the Userform. Hope that helps.

Hi,
I was able to correct the error.

Now when it runs, it creates a new spreadsheet for the vendor but does not populate on the sheets. Basically creating blank files.