Hello! Thank you for looking at my probably confusing Title.

I've created a macro that filters 4 separate columns for individual data, so for the sake of this say Columns A-D. A=Movie genre , B=Movie Length, C=Movie Year, D=Movie Rating.

What I'm wanting to do is in the cells of column E, put an identifier for each different filter combination that I need but have it come off a series or list so if one combination doesn't exist it skips it and goes to the next. So using the example, the list for Column E would be; Try First, Try Second, Try Third, etc.

Is this possible?

The macro I have I can enter data into Column E, but it might skip around; Try First, Try Third, Try Fifth, etc.



Thank you for any help.