autofill

[funkymonkUK]

i have a formula which I need to autofill down a list of data it is an if statement and refers to goes something like this =if($j$1>=j8,if($h$1<=j8,"download","Leave"),"Leave") this formula is put into K8 as I then autofill from k8 down by the forlua you can see that j8 is going to change. any ideas?

[funkymonkUK]

HELP me please I am sure it not that hard.

[mangesh_yadav]

What is your question. Are you asking if j8 will change to j9 and then j10 and so on. Then yes it will. And if you do not want it to change, then use $j$8 instead of j8

- Mangesh

[funkymonkUK]

what I am asking is how do I put that formula into activecell.offset(0,10) which is K8.