Hello I have this formula pointing to a cell on a different sheet;
A1
='Sheet2'!A1
In A2 I want the formula to point to 'Sheet2'!A2 so basically 'Sheet2'!A1+1 row. I thought I could use OFFSET with INDIRECT but was unable to make it work.
As long as you don't have your cell reference set as absolute, you should be able to just copy the formula down the column, and it will iterate the referenced row.
In B1 I want the formula to point to 'Sheet2'!A2 so basically 'Sheet2'!A1+1 row. I thought I could use OFFSET with INDIRECT but was unable to make it work.
But in different cells I could be referring to +x rows or +x columns, so a method would be useful.
I have sheets2 - sheet10, sheet1A1-A10 points to A1 in each sheet, then in sheet1B1-B10 I need a formula that will use sheet1AX+C/+R to pull back info from the respective sheets. I can then drag this formula down and it will work for all the sheets.
I am very confused... can you please provide some sample data and what your desired result is? This is the first you've mentioned sheets beyond sheet 2, and now you're talking about in different cells you'd be moving by a different number of rows/columns.
I am very confused... can you please provide some sample data and what your desired result is? This is the first you've mentioned sheets beyond sheet 2, and now you're talking about in different cells you'd be moving by a different number of rows/columns.