Hi

I have a sheet which requires an advanced filter. To set the range of cells needed I need to have the user enter 2 different letters (being the first letter of the supplier). For example A to F. After that I want excel to autofill a certain range with the following: row 1 = A*, row 2 = B*, ... row 6 = F*.

Can anyone tell me how to do that?

Regards,
Tino XXL