Code help: Combing data from worksheets in a directory.
Hi everyone.
Im still having a bit of trouble editing some code to fit the way i want it. I am using the KBase article 'Combine All Data From All Worksheets in All Workbooks in a Specified Directory' posted by mvida from http://vbaexpress.com/. 1) Instead of scrolling through every worksheet in the tWB workbook, i only want to use one. ("Dashboard") 2) I want to predefine the range i want copied. (A8:Z14) Thanks in advance. Nick |
Code help: Combing data from worksheets in a directory.
|
Code help: Combing data from worksheets in a directory.
Hi nickm687
See this page http://www.rondebruin.nl/copy3.htm in the examples I use the sheet index 1 You can change mybook.Worksheets(1) To mybook.Worksheets("Dashboard") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nickm687" wrote in message oups.com... Hi everyone. Im still having a bit of trouble editing some code to fit the way i want it. I am using the KBase article 'Combine All Data From All Worksheets in All Workbooks in a Specified Directory' posted by mvida from http://vbaexpress.com/. 1) Instead of scrolling through every worksheet in the tWB workbook, i only want to use one. ("Dashboard") 2) I want to predefine the range i want copied. (A8:Z14) Thanks in advance. Nick |
Code help: Combing data from worksheets in a directory.
On 2 Apr, 17:54, "Ron de Bruin" wrote:
Hi nickm687 See this pagehttp://www.rondebruin.nl/copy3.htm in the examples I use the sheet index 1 You can change mybook.Worksheets(1) To mybook.Worksheets("Dashboard") -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "nickm687" wrote in ooglegroups.com... Hi everyone. Im still having a bit of trouble editing some code to fit the way i want it. I am using the KBase article 'Combine All Data From All Worksheets in All Workbooks in a Specified Directory' posted by mvida from http://vbaexpress.com/. 1) Instead of scrolling through every worksheet in the tWB workbook, i only want to use one. ("Dashboard") 2) I want to predefine the range i want copied. (A8:Z14) Thanks in advance. Nick- Hide quoted text - - Show quoted text - Thanks Ron, very usefull. Nick |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com