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.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …