Multiple source columns in different Excel sheets

Question

I have a very large Excel file (DB Export) that contains multiple sheets that have different source columns (e.g. Sheet 1/Source column C; sheet 2/source column E; sheet 3/source column F). 
 I already tried Excelling Studio for this, but I can only define one source column and not different source columns for the different sheets. 
 
 Does anybody know about a solution for this?

Paul Filkin · Answer

Michaela Moosbrugger If you just have one file, or maybe only a few, then I think your best solution is to save the individual worksheets as separate files, and then handle them in Studio as needed. It might be more effort to try and automate the process. Once you complete the translations putting the workbook back together is simple.

Paul Filkin · Answer

[deleted]

Paul Filkin · Answer

Thanks Evzen... I spent a little bit of time on this and managed to partially make it work (badly), but I think it's too specific, and more of an example, to be really useful for the audience in this user forum. I'm sure Kelly is actually trying to be helpful, and I'm sure it works for her, but I really don't think it's appropriate for here. 
 
@ Kelly ( ) 
It's enough to provide a link to your helpful solution, and after that I think you should leave it at that and don't keep adding more posts about the code you wrote (I removed your post with the VBA into the AHK forum as it's not an AHK script). Most users in this forum are not developers or scripters so won't have the technical ability required. You can write all you want on your own site and as I already suggested you can link to there. Then we won't be inundated with posts that nobody can follow properly.

Trados Studio > 1. Trados Studio

Multiple source columns in different Excel sheets