Filling same value in cells between two specified drop down years

[bopha99]

I have a number that I would like to have placed in the same row between two drop down years that are specified on a user input page. The user would define the title of the row, the amount for that row, and a drop down of years that amount would appear. What is the code to have excel place the same value in the cells in between the two years in the drop down menu? Thanks.

[SamT]

I don't understand.

What is a "user input page"?

Can you post an example of what you now have completed?

[bopha99]

I think I figured it out. I would just use a combination of if(and( statements.