Autoscroll through drop-down without hard coding the name of each value

I have reports that generated and sent to me each month. For now I need to separate the data that's in each report by the physical locations in column A. The list of sites is dynamic and changes from month to month.

I'm looking for a way to select each unique value in column A, activate the range and save that range as a unique file without hardcode the actual value. I've done something similar in the past but I can't think of a simple way to do it in this exact situation.

I have my initial skeleton/idea below. Any suggestions would be greatly appreciated

Please Login or Register  to view this content.

I took a drive and the solution came to me. I did modify the above code and it works perfectly only scrolling through the unique values.

process I took: Create a temporary list of unique values, named the list, used index fx and a static variable to increment through the list and gernate a unique file for each selection.

Turned out to be pretty easy!!