Hi all

I have a form where users enter a quantity into a cell (eg cell D6 =
450,000) and enters a number of weeks into a second cell (eg D1 = 10).

I have 52 columns (ie 52 weeks) in columns BA6:CZ6 which I'll call the
"thousands grid".

I need a formula in each "thousands grid" cell to:

- Determine if it's equivalent cell is 0 (eg in range A6:AZ6 it will find
that D6 is0),

- Go to that equivalent cell in the "thousands grid" (BD6) and calculate
the value it found (in this case in cell D6) divided by the number of weeks
in cell D1

- then repeat that formula in the next X cells to the right (X = number
quoted in D1).

So what I'm trying to do is split the value found on the row by the number
of weeks entered and report that figure in each individual cell over the
period.

I hope that makes sense.
I can't do a pivot table or anything like that because this is one of many
functions occurring on my spreadsheet.

Any help would be greatly appreciated as always.
--
Thank for your help
BeSmart