Macro 4 copy & paste between 2 books/files
Hi Guys,
Can you devise a macro that when I open two workbooks of similar structure, one with the macro, and run the macro the data on the other opened sheet is copied and pasted on the macro containing book. Next time I run the same code the data is again copied from the other sheet and pasted on the macro possessing workbook but in the end, i.e. after non-blank rows. Thanks in advance |
Macro 4 copy & paste between 2 books/files
See Ron de Bruin's site
http://www.rondebruin.nl/tips.htm Browse through the section on Copy/Paste/Merge examples Gord Dibben MS Excel MVP On Sun, 7 Oct 2007 10:07:00 -0700, FARAZ QURESHI wrote: Hi Guys, Can you devise a macro that when I open two workbooks of similar structure, one with the macro, and run the macro the data on the other opened sheet is copied and pasted on the macro containing book. Next time I run the same code the data is again copied from the other sheet and pasted on the macro possessing workbook but in the end, i.e. after non-blank rows. Thanks in advance |
All times are GMT +1. The time now is 12:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com