Hi
Every week we receive a list of clothing articles in 25 different languages. That's a separate Excel file for each language. We then need to copy the first column from each of the 25 Excel files and paste them into the same final, single spreadsheet. The order of languages in the final spreadsheet is always the same so we would have for example Column A (English), Column B (French), Column C (Spanish) etc. and we have to go to the English spreadsheet, copy Column A and paste it into Column A of the final spreadsheet, then go to the French spreadsheet, copy column A and paste into Column B of the final spreadsheet, then go to the Spanish spreadsheet, copy column A and paste it into column C of the final spreadsheet.
We have to do this every week for 25 languages. I'm sure there must be a good and fairly easy way of automating this.
Can anybody help?
It would be much appreciated.
Thanks
Bookmarks