Sounds crazy, but a colleague told me one can make a spreadsheet from text data by using tab delineation instead of comma (CSV). I have a circumstance it which it would be better to produce a tab separated file instead of CSV and then just rename it ".XLS". I tried it, and it works just fine!
However, I need to have more than one sheet in the Excel file. Is there a command that I can put into the text file to cause the data that follows it to be on a new sheet?
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
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 …