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.