Hi everyone,

I've got a nice Excel challenge that I can't solve.

I have a file where the year and quarter for the data have to be selected in a dropdowns (J1 and J2). Then, the columns 'YEAR' and 'QUARTER' should automatically be filled with the selections made. That I can manage, but then I want this to happen for every row that is populated, a number which can differ. For example, sometime the column "Country description" can have 5 entries, but i can also have 20. So I want the Year and quarter columns to, respectively have 5 and 20 rows filled with the Year and Quarter selections. So I'm looking for a way to have this adapt to the number of rows filled in in columns C - F.

Example file attached If anyone can help me with this that would be great!

Excel Year Quarter.xlsx