Autofill cell reference forumula not working
=INDIRECT("D"&(ROW()-7)*69+46)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"James D" wrote in message
...
Hi.
I have a row in which each cell references another cell.
Format looks like this:
U7 =D46
U8 =D115
U9 =D184
Notice that each cell is still referencing column D, but moves up in
sequence by 69
When I highlight and drag (I need to continue this series all the way to
U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does
not
maintain the series.
Driving me bonkers, what do I need to do to continue the series without
manually entering the formula? Done right, U10 should be =D253, U11
shoudl
be =D322, etc.
--
Thank you all for your help!
|