elmnas
03-10-2015, 01:55 AM
Hi guys,
I have made a script that does following stuff:
1. Split all sheets to each file orginal name + sheetname.
example: test_sheet.xls
2 for each sheetfile. the script split each column to a new file(because each column contains on first row a cell that represent the language for the column)
the script gives then the name:test_sheet_en.xls
now is the hard part...
I need a script that
put back all the columns to each sheet then put each sheet back to the orginalfile on same place in the orginal file
Could someone help me out?
I know this sounds pretty complicated but if you got time http://www.excelforum.com/images/smilies/smile.gif
Thank you in advance
I have made a script that does following stuff:
1. Split all sheets to each file orginal name + sheetname.
example: test_sheet.xls
2 for each sheetfile. the script split each column to a new file(because each column contains on first row a cell that represent the language for the column)
the script gives then the name:test_sheet_en.xls
now is the hard part...
I need a script that
put back all the columns to each sheet then put each sheet back to the orginalfile on same place in the orginal file
Could someone help me out?
I know this sounds pretty complicated but if you got time http://www.excelforum.com/images/smilies/smile.gif
Thank you in advance