Simple macro too export range of cols between two w/books .

[Sunline]

Hello all , again have looked thru past posts but not found a simple
macro following .

I want too export from book1 , sheet1 , cols range CG2:DJ2 all data in every row
containing any type of text or numbers including currency etc .

There are 170,000 rows so some speed would be good .

Export too book2 , sheet1 , col range CF2:DI2

Some cells will be blank so leave blank , basically if a photo was taken of book1
data too export it will look and fit into book2 cols CF2:DI2 fillng all 170,000 rows .

I have never done this before any pointers to help will be appreciated . I usually leave out some vital info on my posts but not intentional .

Thanks .

 

[Sunline]

ok , sounds good but i have no idea what you just said , whats involved please to
"transfer source data" too get macro to work along these lines .
Thanks , your help is appreciated .

 

[Sektor]

I mean that when you copy your range, you don't copy source data on which some formulas in that range are based on. Thus, you need to copy source data too.

 

[Sunline]

Ok ,understood , thanks for all your help .