ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste a value a set number of occurences (https://www.excelbanter.com/excel-discussion-misc-queries/71772-paste-value-set-number-occurences.html)

Larry

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?


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com