Hello eveyone,

I'm trying to create a cashflow for every month for a particular job contract. For example lets say I have £200,000 in total but due to the nature of the work we will only be paid in installments over x amount of months. I could easily do this by picking the cell number and dividing it by lets say 4 months and copying the answer into 4 cells.

My question is, will I be able to use a formula, that allows myself or anyone else who edits the document, to simply select the cell value and simply drag it over x amount of cells and divide by the numbers of cells within the set range?

I hope I've explained this sufficiently but feel free to ask further questions.