Hi there,
I have in cell D4 have =C4*Who!AR1
I have in cell D4 have =C5*Who!AS1
I have in cell D4 have =C6*Who!AT1
I need to fill down the above formula but not sure how.
help would be appreciated.
Thanks.
Hi there,
I have in cell D4 have =C4*Who!AR1
I have in cell D4 have =C5*Who!AS1
I have in cell D4 have =C6*Who!AT1
I need to fill down the above formula but not sure how.
help would be appreciated.
Thanks.
Highlight all 3. There should be a little square on the bottom right. Click and hold that, then drag down as far as you can (or want to... that is...).
Thanks for that but that will increment the rows not columns.
your suggestions will do the following
Cell D4 =C4*Who!AR1
Cell D5 =C5*Who!AR2
Cell D6 =C6*Who!AR3
I want it to do
Cell D4 =C4*Who!AR1
Cell D5 =C5*Who!AS1
Cell D6 =C6*Who!AT1 and so on.
So it will fill down in C column but fill right in Who sheet AR, AS, AT, AU, AV and on.
I hope this makes sense?
Have a look at this
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks