How far along are you? What are you stuck on?
Have you got/set an object reference to an Excel application?
Do you know the name of both workbooks?
Do you know the worksheet names?
Do you know the location (range) in the first worksheet that is to be copied.
Do you know the range in the second worksheet where the data is to go?
i am slightly new to VB, and I am currently working on a project for work where i need to get it to copy 3 lines of information from one excel sheet and paste it onto another and then skip 2 lines and do it again... i have been trying for almost 2 weeks to figure it out but i guess i am just too new at this to get it to work... please help i just need to know how to tell it to copy 3 lines and then how to skip 2 before it does it again... thanks!