Searching around the forums and I haven't been able to find a solution. I would like to do the following:
  • Create a new workbook with two worksheets - Done
  • Prompt the user to select a text file that contains the data - Done
  • Take the text file and popluate it into one of the sheets in the new workbook - don't know how to do
  • Take the data in the new sheet and create a summary in the remaining sheet in the new workbook - don't know how to do
  • In order to create the summary, it would have to apply formulas to the new workbook - don't know how to do.
The idea is to have the main workbook that could go out and create a new workbook and do the data analysis. It would be up to the user to save the new workbook. But the bulk of the work will already be done for them.
Thanks in advance.
BTW, I don't have any source code to share yet. Just bits for the creation and prompt of the user is complete.