Hello,

Here is my problem. I have a big Excel file (file 1) that contains product descriptions in English with multiple worksheets, where each worksheet corresponds to a brand. For each worksheet, every line corresponds to the description of a product and there is only one column. For each worksheet, there are lines that are hidden and some of them are blank, while others have some data entered.

I also have another file (file 2) with the same structure, the same product descriptions and the same hidden lines, but all the descriptions are translated in French.

What I want to do is to copy the column with the French description from file 2 and create a second column with this data in the file 1. By this, I will have a file with 2 columns, one with English descriptions and one with French descriptions.

I tried the following but it did not work:
1. Select the column 1 on file 1 and click on Select Visible Cells only
2. CTRL + C
3. Select column 2 on file 2 and click on Select Visible Cells only
4. CTRL + V
I get the message: The command cannot be used on multiple selections. I saw on the forum that there are some macros, but I have never used one and I am not sure that they would work in my case.

Thanks for the help!