Hi all,
I have a source document which gets data added across columns but always in the same row, i.e. B4 on Monday and then C4 on Tuesday. However, I have another page which needs to display this same data but down columns, so Monday will be b4, and Tuesday B5.
So far I have tried multiple versions of the formula below, I can't get it to go across columns when dragged down rows on the display page. It does however update if I pull it across columns.
=OFFSET(Sheet1!B$4,0,0,ROW()-4)
Cheers.
Bookmarks