I'm trying to drag the formula horizontally.
=OFFSET('Data Input'!D655,$AB$2,,,)
I want the cells to BE UPDATED IN this format
A1= =OFFSET('Data Input'!D655,$AB$2,,,)
b1=OFFSET('Data Input'!D656,$AB$2,,,)
C1=OFFSET('Data Input'!D657,$AB$2,,,)
D1=OFFSET('Data Input'!D658,$AB$2,,,)
E1=OFFSET('Data Input'!D659,$AB$2,,,)
Tried using $ sign E1=OFFSET('Data Input'!$D655,$AB$2,,,)...but it is still not working..Am i missing any thing. ?
Bookmarks