Copy-Paste Value based on user defined range

T

tushargarg729

Hello,

I am trying to create an option such that, the user can input a default
value in one cell, enter a start year, and the number of years he wants
to assign this value for.

Ex.
A B C
1 Value Start Year # of Years
2 500 2005 5

Apply 500 starting in 2005 for the next five years including 2005.

I am working in Excel2000. Thanks for your help
 
Top