Help with copy text from one workbook to another.

**jcranst** · 05-02-2012, 08:10 AM

Here is what I came up with using the macro recorder. The Report Template.xlsm is the sheet containing the macro.

Please Login or Register  to view this content.

It opens the sheet and then just stops. Any Tips?

**arlu1201** · 05-02-2012, 08:25 AM

Your code states

Please Login or Register  to view this content.

Shouldnt it be

Please Login or Register  to view this content.

Also you can change this part

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

This code will copy the data from the 1st worksheet of the Template for vlookups file to the 1st worksheet in this workbook (Report template which contains the macro) in column B - last available row.

**jcranst** · 05-02-2012, 09:04 AM

Thanks for the reply. The macro seems to stop after the vlookup sheet is opened.

Please Login or Register  to view this content.

I added the Msgbox at the end to see if the macro keeps running. The message box does not appear.

**arlu1201** · 05-02-2012, 09:07 AM

Why dont you attach a sample of both your files? It will be easier to troubleshoot.

**jcranst** · 05-02-2012, 10:00 AM

I got it! Thanks for your help. After some more google searches I found that having shift in your keyboard shortcut stops the macro when opening sheets. I am still not sure why. I changed the short cut and it works.