How to copy cells to same place but in another document?

[elmnas]

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

[ValerieT]

Not sure I follow: each sheet become a file, then each column gesto a new file too? all these steps seems complicated for nothing, so I probably don't understand. May be with a sample or at least a detailed example?

[elmnas]

already solved :)