Copy and Paste Depending on Cell

[Craig2097]

Hi,

I want to look at column B and then anything that has say EUR i want to highlight all of the rows which have this value and the corresponding information in columsn A to L, then copy this information onto a new workbook in cell A1.

I then want the macro to go through all the currencies and do the same, so GBP, CHF, USD etc.

Any help would be much appreciated. Thanks.

[excelxx]

Hi craig

I have added some code to your file, though I have referenced column C as that was the column with the currency data. You may need to change it.

Let me know if it is ok.

[Craig2097]

Hi,

that works great thanks and yes you were correct it was column C i wanted. such a school boy error. I can now mess around with this code as want to do some other things to the sheet, but best to learn by doing as they say.

Thanks and have a good one.