Referencing Sheets By Name in Excel
Posted on 2015-01-18
I have a worksheet that has a sheet for each event that I time. I want to keep a summary page, referencing the sheets themselves by name and values on those sheets on the summary page. So really I have two questions:
1) How can I reference the sheet names in a cell on the summary page so that I can just drag down and fill based on the sheet number. This would be what I want in column b.
2) how can I incorporate cell values from sheets by sheet number rather than by sheet name in my formulas.