Hi,
I hope someone can help.
I Have a number of identical worksheets all with mulitple formulas contained within and i am looking to create a summary sheet i have used the $ sign to stop the rows increasing as i drag and the formula but i cant get the sheets to increase by an increment of 1 i.e.
formula in A1: ='Sheet1'$B$3 when i drag to the right i want the formula to show ='Sheet2'$B$3 constantly increasing the sheet only for every cell right i drag.
Is this even possible, i've been going round in circles for hours!!
Many thanks in advance
Smarty
I hope someone can help.
I Have a number of identical worksheets all with mulitple formulas contained within and i am looking to create a summary sheet i have used the $ sign to stop the rows increasing as i drag and the formula but i cant get the sheets to increase by an increment of 1 i.e.
formula in A1: ='Sheet1'$B$3 when i drag to the right i want the formula to show ='Sheet2'$B$3 constantly increasing the sheet only for every cell right i drag.
Is this even possible, i've been going round in circles for hours!!
Many thanks in advance
Smarty
