Copying Multiple Columns from One Worksheet to another

[skellz022782]

Hi Everyone-

Hoping someone could help me with some code I'm struggling with. We work with Timberline Accounting Software at my company which has a specific format for importing Data. The data I'm trying to import in this case is Fuel from a vendor invoice. I'm writing a macro that will copy columns of data off his invoice and paste it into the right section of the import format for our accounting system. My code is below:

Please Login or Register  to view this content.

I want to do copy and pasting for multiple ranges. Any ideas on what the best way to do this is? Also, something is incorrect with the syntax on my destination for the range copy.

Any help would be appreciated.

Thanks.

[skellz022782]

I feel like an idiot. I forgot to set the worksheets. Aside from that, Is there a better way to do this than copy and set the destination up for each copy?

Thanks!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.