Macro for Copy/Paste from one workbook to another in Excel 2007

**Blackjack12** · 09-19-2012, 07:56 PM

Hello!

I am trying to write a macro that copies data from one sheet in a workbook to another sheet in different workbook in Excel 2007. I could really use some guidance on what to do next. Here's the details. Both workbooks will have their own name that will not change over the time the macro is used. ie. Workbook1 and Workbook2 I am looking to copy Column A through Column G every time I run the macro from Workbook1 to Workbook2. The columns will not change. The rows may be longer or shorter each time the workbook1 is updated. Workbook 1 will be updated manually. I was hoping for workbook2 I could run a macro. I tried the record macro feature in excel and it works fine for the first time. But, the second time it does not paste the updated data in workbook1 to workbook2. It's like it references the data that is already on the clipboard not the new data in the workbook. Does anyone have code to make this work or a reason why this is not working? I would really appreciate it.

**jaslake** · 09-19-2012, 08:46 PM

Hi Blackjack12

After you've pasted your data add this line of code

Please Login or Register  to view this content.

Better yet...post your code

Better yet...post your workbook.

**jayinthe813** · 09-19-2012, 09:39 PM

@Blackjack

It doesnt work the second time most likely because you need to give it proper references. Recording will give you the layout, but then you will need to go refine the code to make it dynamic if need be, such as if data changes, you need to tell it to go to the last row and copy over from there, each time. You have not specified whether you want to fully replace data in workbook2 each time you run the macro, or create a updated list, adding everything from workbook1 into the next available space in workbook2. Post the code you are working with as well.

**Blackjack12** · 09-19-2012, 10:13 PM

Thank you Jaslake for your code. I am going to try this first thing in the morning when I will have the file. If it doesn't work I'll send my code over along with an example of the workbook. Jayinth813, that makes complete sense. I am looking to fully replace the data in workbook2. I'll see what happens in the morning. Thank you both!

**Blackjack12** · 09-20-2012, 08:54 AM

Thank you Jaslake for your code! It seems to work just fine. It looks like it is clearing out the memory and pasting the newest data available. Thanks again!

**jaslake** · 09-20-2012, 10:01 AM

Hi Blackjack12

You're welcome. If that satisfies your requirement please mark your Thread as SOLVED.

**Cutter** · 09-20-2012, 11:53 AM

@ Blackjack12

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.