Copy & Paste visible cells only

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!

Hi,

Since your sheets are identical, what is preventing you from unhiding rows/columns on both sheets prior to copying and pasting?

If that is not possible, you could enter formulae in each of your desired destination cells in the English version to obtain the relevant data from the French version. If, as you say, the two sheets are identical - and so cell A1 in the English sheet corresponds to cell A1 in the French sheet, and so on - then this will be straightforward.

If they are not identical, then provided you have some sort of unique identifier for each of the rows you wish to import, you can use other formulae to bring the data over. In this case, however, it would be helpful to see a sample of your workbook(s).

Regards

Easier if you had posted a sheet... This should do it, though:

http://www.excel-user.com/2012/05/co...ells-only.html