View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larry
 
Posts: n/a
Default Paste a value a set number of occurences

Using Excel 2000

I am pulling an inputted number from one cell...call it 15
and an imputted value from another cell...call it $100
What I am trying to do is create a formula that "pastes" the value $100 - 15
times starting in a given cell and moving down by row.
Obviously, both the 15 and the $100 can be changed by the worksheet user.
Does anyone know a simple way to do this?