I am using Excel 2003 and would like to insert a formula that would plug a
number in each cell (each cell represents a different week) based on a the
duration of a contract (given in weeks)

For example, a contract's duration is 14 weeks, I would like to have each of
our weekly cells automatically display a sales figure (eg. 600 dollars)right
until the contract expires.

Cell A1: Contract duration (in weeks)
Cell B1, C1, D1..........(calandar weeks)

Any ideas?