i have 100 sheets from '1 to 100', i have same values in every sheet. i used $ operator to keep constant the cell number, when i drag the formula down, it keep the right value but it don't change the sheet number.
e.g.
i have a value "Apple" in Sheet1!A2, Same value in Sheet2!A3 and go on till Sheet100. i need a formula so i can drag and it changes the sheet number no the cell number....hope you understand my question....