Add sheet to existing Excel file

Question

Hello Everyone,

I have over 100 files, each with one tab, saved to my desktop and I need to add a second tab to each file. Basically, I have 100 surveys and need to add an instructions page to each survey. I have tried using macros, but no luck. Another problem I'm having is the formatting. I want the surveys and instructions to maintain its original formatting. I'm not sure if this is possible, but I ultimately need 100 separate files (surveys) with two tabs. One tab being the original survey and the second tab being the instructions.

Thanks,

James

JamesG21 · Answer

I included sample data. I'm trying to add the instructions tab to each survey.

Sample Data.zip

JamesG21 · Answer

Thanks Mceleavey!

I tried your solution, but I'm still having trouble adding the instructions. The instructions are in a separate Excel file, so I replaced the Text Input tool with an Input tool. I'm able to add an instructions tab to my surveys. However, the instructions tab is blank and the file gets corrupted. I'm not sure what I'm doing wrong.

Thanks,

James

JamesG21 · Answer

Thanks Binuacs and Mceleavey!

Mceleavey I tried your solution, but I'm still having trouble adding the instructions. The instructions are in a separate Excel file, so I replaced the Text Input tool with an Input tool. I'm able to add an instructions tab to my surveys. However, the instructions tab is blank and the file gets corrupted. I'm not sure what I'm doing wrong.

Thanks,

James