I have Sub TestTable in the file BacktestFile.xlsm that processes data of the single (active) sheet at a time and copies results to the added new sheet with the (same name) + T. The aim is to make it automatically loop through all sheets (except Sheet1) in the file BacktestFile.xlsm and add new sheets with results to workbook Results.xlsm with names identical to names in the source file (BacktestFile.xlsm). The sub works well within the same workbook, but I could not make it transfer data to another workbook. I run across problem of assigning name to the new sheet, it would always give error message that the sheet with this name is already there. I would be grateful for any help in solving this problem. Please find attached BacktestFile.xlsm with Sub TestTable, and file Results.xlsm with results as they should look like after data processed automatically (I added sheets with results to file Results.xlsm manually), as an attachment to this post.
Thanks in advance.