Cell drag handle

[D Willett]

Sorry to take all your time guys ( two posts in 1 day ).

With the following formula:

=OFFSET(INDIRECT("DueToday!C1"),Admin!$F$2,0,1,1)

Using the drag handle doesn't change the formula. It should result in the reference in the string "C1" changing to C2, C3, C4 etc as it is dragged down, or D1, D2, D3 etc if dragged right.
Instead, the formula is replicated instead in each cell.

Really annoying having to edit each cells formula manually.
Is there a quicker way or keyboard shortcut??

Kind Regards

[HansV]

If you want the cell reference to be updated, don't use INDIRECT:

=OFFSET(DueToday!C1,Admin!$F$2,0,1,1)

[D Willett]

Thanks Hans

I'm trying to remember why we used INDIRECT? Its from a project we worked on last year sometime, it escapes me now...
But, if your recommendation works then great stuff.

Thanks again.

[HansV]

It might be the following: If you insert a column to the left of column C, the formula will automatically change to

=OFFSET(DueToday!D1,Admin!$F$2,0,1,1)

Similar for inserting a row above row 1. Using INDIRECT is a way to avoid that.