I need some help with the attached template please. Code/formulas required to:
1. Auto line count formula from cell A2 in the worksheet "Fund ref database"
2. In cell C66 of the "Fund Template", I need the fund limit to be programmed to automatically show 5%, 7% or 10% depending on if cell C26 has either "Money Market", "Fixed Income" or "Equity" selected respectively. I cannot remember how to write the IF statement for this task.
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…