Help with copy certain data from one sheet to another

Hello

I try to understand how things works, and need a little bit help

I have this vba from Jolivanes here at this board he help me yesterday, Now i try to modify it to use in another wb, i try to copy column from sheet2, Column JQ to JW row 18 + KS and KT to Sheet 1 Column A-G and I-J row 9

i counted JQ to 277 but i did not sucsess

Please Login or Register  to view this content.

I'm not sure how your subject relates to the actual question, you do realise you can write

Please Login or Register  to view this content.

to avoid having to count the columns?

Anyway, just try something like this

Please Login or Register  to view this content.

Be aware, however, that if you use the "Copy" method, any relative cell references will be adjusted to their new location. Personally, I'd use the "xxx.value = yyy.value" method & pre-format those cells the values are going into if necessary.

Looking at the original code, I see there are reference errors "#REF" on your worksheet. That may be a result of using the "xxx.copy" method.

Tim

One way...

Please Login or Register  to view this content.

Hello

Thanks you both,