Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code help: Combing data from worksheets in a directory.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combing 2 lists of data | Excel Discussion (Misc queries) | |||
Vlookup and/or combing data from two worksheets | Excel Worksheet Functions | |||
Combing Info. from multiple worksheets | Excel Discussion (Misc queries) | |||
combing cells with same data | Excel Programming | |||
Combing source data from 2 worksheets. | Charts and Charting in Excel |