I'm sure there is a simple elegant solution, but I cannot find it.

On a variables sheet the date of new staff joining is set. Each new member of staff gets their own sheet and own start date. Thus on a many other sheets those data are fed through.

In the example below the third row is on a completely different sheet. For each sheet we need to multiply the value in the second row, with the %age.

Currently each sheet is adjusted manually by inspection. However the percentages are always the same it is just the start date that changes and then the %ages are reference in order.

I can solve the problem inelegantly by searching for non 0 value and then getting the cell location and feeding it back in to the formula. However this takes two rows on the spread sheet to achieve the task. Ideally I want to find an elegant solution as there are several instances with similar issues and having a lot of cell referencing on the sheets rather highlights my incompetence.

Jan Feb Mar Apr May Jun Jul Aug
0 0 0 1 1 2 3 1
2% 3% 4% 5% 6% 7% 8% 9%
0.02 0.03 0.08 0.15 0.06

The last row of figures in this case is the desired result, starting in April (i.e. the staff's start date)

Thank you for you time in reading this regardless of if you are able to help.

Cheers