- Joined
- 1 Jan 2013
- Messages
- 418
- Likes
- 699
- AFL Club
- Melbourne
Hi all
Excel can be fun and frustrating and I'm sure there are quite a number of people on the site using it to varying levels to help work out Supercoach scenarios and planning. I'm advancing my skills (mainly b/c of Supercoach) and am happy to help anyone where I can.
But to start this of I am posing a question that has me stumped in the hope that any EEs (Excel Experts) can help me progress.
I am starting up a series of workbooks in readiness for next year. And to create this, I am using this year's data and my weekly teams to get it started. I have all data in a separate workbook with sheets corresponding to each round. I then have my "Year" book which will have my team and weekly changes (I can then replicate the workbook for testing scenarios). In this workbook to save me retyping sheet names into formulas for each separate round, I'm sure I have seen somewhere where you can add the text from a cell (ie O1 in the image below) to match part of the formula (as highlighted). So when I replicate the sheet for Round 2, I can just put in R2 in O1 and it will look at the sheet [STATS Book.xlsx]R2_FF"!.
I have done some searching but can't phrase the search correctly to find what I need. Hoping someone will have some answers they can share.
Many thanks, Stephen
Excel can be fun and frustrating and I'm sure there are quite a number of people on the site using it to varying levels to help work out Supercoach scenarios and planning. I'm advancing my skills (mainly b/c of Supercoach) and am happy to help anyone where I can.
But to start this of I am posing a question that has me stumped in the hope that any EEs (Excel Experts) can help me progress.
I am starting up a series of workbooks in readiness for next year. And to create this, I am using this year's data and my weekly teams to get it started. I have all data in a separate workbook with sheets corresponding to each round. I then have my "Year" book which will have my team and weekly changes (I can then replicate the workbook for testing scenarios). In this workbook to save me retyping sheet names into formulas for each separate round, I'm sure I have seen somewhere where you can add the text from a cell (ie O1 in the image below) to match part of the formula (as highlighted). So when I replicate the sheet for Round 2, I can just put in R2 in O1 and it will look at the sheet [STATS Book.xlsx]R2_FF"!.
I have done some searching but can't phrase the search correctly to find what I need. Hoping someone will have some answers they can share.
Many thanks, Stephen