0
Undo
Votes
Hi,
I need help in one of excel formula where the formula needs to be changed horizontally when dragged, but this works only vertically, I need this in order to calculate Total Breaks from reference cell for each day.
='6th Feb'!K3 ( COLUMN "B") now when I drag this vertically it changes as ='6th Feb'!K4, ='6th Feb'!K5,='6th Feb'!K6 .which is good now I need this to be the same way for Horizontally along with date change and cell reference to be changed, but its not happening. Please help.
Big Thank you in advance.
I need help in one of excel formula where the formula needs to be changed horizontally when dragged, but this works only vertically, I need this in order to calculate Total Breaks from reference cell for each day.
='6th Feb'!K3 ( COLUMN "B") now when I drag this vertically it changes as ='6th Feb'!K4, ='6th Feb'!K5,='6th Feb'!K6 .which is good now I need this to be the same way for Horizontally along with date change and cell reference to be changed, but its not happening. Please help.
Big Thank you in advance.
There are no replies made for this post yet.