Need help with what if analysis

I couldn't make what if analysis data table

first row is ok but others returning same number

variable is @ row 13

that should change for each month

If anyone could check whats wrong with it

I really got frustrated

I can't see the same numbers anywhere.

The analysis starts @ row 30
I want it to change c17-j17 for each month
The first month/row in the data table is fine
But i couldnt make it for the rest
Thanks for the reply

I don't know if you think that response answers my question, but it certainly makes nothing clearer for me.

Not sure I understand your question, but maybe
C13 should be =C30
and then copied across though D13:J13

i'm sorry if i wasn't clear

my problem is when i make a what-if-analysis data tables

the results for the changed variable is the same

but not for the first row

i've done the same with other cell and it worked fine

but when i used it on C13 it didn't work the way it should

i hope these pictures would clear things up and i will upload a new sheet used in the pictures

this shows the problem:



this what it should be like:



i made what-if-analysis on another cell and it worked fine:

Roger Govier said:

Not sure I understand your question, but maybe
C13 should be =C30
and then copied across though D13:J13

Click to expand...

that worked and thanks for that

but i may change the cells and can differ from C13