palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I've always struggled getting my head around indirect, to the point where I'm, not really sure if this is the function I need to use in this particular instance ...
In my current worksheet, I'd like to return the contents of a cell from a different worksheet (same workbook though) ... however the cell I need to refer to can change from week to week.
For example the formula this week might be ... ='This weeks'' fixtures'!C13 but next week might be .... 'This weeks'' fixtures'!C29
so, in my current sheet I have a designated cell (cell N9) which the user is meant to enter the row number that's relevant for that particular week
So, if the user types 18 into cell N9, I need the formula to refer to the following cell .... 'This weeks'' fixtures'!C18
How do I make the formula dynamic like that ?
and on the same worksheet, I need a formula to refer to a cell range (not just a single cell) which will also be changing from week to week.
So I've got two other designated cells the user would need to enter certain row values into (cells N11 and P11), so, if the user types 34 into cell N11 and 48 into cell P11, I need the formula to refer to the following cell range .... 'This weeks'' fixtures'!C34:C48
Is anyone able to help me ?
Kind regards,
Chris
In my current worksheet, I'd like to return the contents of a cell from a different worksheet (same workbook though) ... however the cell I need to refer to can change from week to week.
For example the formula this week might be ... ='This weeks'' fixtures'!C13 but next week might be .... 'This weeks'' fixtures'!C29
so, in my current sheet I have a designated cell (cell N9) which the user is meant to enter the row number that's relevant for that particular week
So, if the user types 18 into cell N9, I need the formula to refer to the following cell .... 'This weeks'' fixtures'!C18
How do I make the formula dynamic like that ?
and on the same worksheet, I need a formula to refer to a cell range (not just a single cell) which will also be changing from week to week.
So I've got two other designated cells the user would need to enter certain row values into (cells N11 and P11), so, if the user types 34 into cell N11 and 48 into cell P11, I need the formula to refer to the following cell range .... 'This weeks'' fixtures'!C34:C48
Is anyone able to help me ?
Kind regards,
Chris