Excel基于下拉选择填充逐年递增年份行的问题求助

Hey everyone, I'm stuck on an Excel problem and haven't been able to find a solution that fits exactly what I need after digging around for a while. Let me break down what I'm trying to do:

I've got a dropdown list where users can select a number of years from 1 to 50. Based on that selection, I need to automatically populate that many rows in a table. Each row should show an incremental year starting from the current year. For example, if someone picks "7", I want seven rows filled with years starting at 2023 and ending at 2030 (since 2023 +7 = 2030—so each row steps up by one year until we hit that end year).

Does that make sense? I'm hoping someone can point me in the right direction here.

I've already tried using Excel's VLOOKUP and INDEX functions, plus some VBA modules I found, but none of them have worked exactly how we want the table to populate.

Thanks so much for your help!

备注：内容来源于stack exchange，提问作者W Teater