I have attached an excel with Sheet 1 & 2, where Sheet 1 have some data and in sheet 2 i have entered a formula in cell D7.
I need a formula to increase the Column number by dragging it to next cell,
For Eg: in Cell D7 i have formula =SUM('Sheet 1'!D4:D44) and if I drag it to D8 then it should be =SUM('Sheet 1'!E4:E44) and so on.
Pls provide your inputs.