Macro for copying 3 columns from one worksheet to another worksheet?

[kishengiggs1]

I need some help creating macro for copying 3 columns from sheet1 (workbook1) to workbook2 and 3 columns from sheet2 (workbook1) workbook2 and it should paste from where the data from sheet1 (workbook1) ended and i will have to do this from 3 more different sheets from workbook1.

I will be doing this everyday so i want to make sure it the pasting gets done from where the previous copied data ended last.

Any help would be appreciated.

 

[John Davis]

Thanks alot. It works like a charm. Greatly appreciate your help.

You're welcome. Thanks for the feedback.

 

[kishengiggs1]

As i said earlier, it works perfectly. There is one small problem though. My macro is stored in Book4.xlsm but if i run the macro from Book4 it does not work.

If i run the macro from any other workbook it works.

Let me know if you can fix this problem, otherwise its ok.

 

[John Davis]

As i said earlier, it works perfectly. There is one small problem though. My macro is stored in Book4.xlsm but if i run the macro from Book4 it does not work.

If i run the macro from any other workbook it works.

Let me know if you can fix this problem, otherwise its ok.

Only suggestion I can make is that I'm using 2003 and I know you have 2007 or later. So if you review the code you'll see that when referencing Book4 is Book4.xls perhaps if you changed those too Book4.xlsm it would work? Don't know if I could add much more.