| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write a macro to club data in multiple excel workbooks into asignle one???
Hi...
I want to write a macro to club similar data present in different work books into a single work book. This macro should be dynamic in itself means that if I'm varying the number of rows (because of increase or decrease in data next time) in these individual worksbooks when I run the macro then it should be able to take these total number of rows into the new work book. Please help me in either writing a macro for this kind of problem or with a source code. Thanks and Regards, Dinesh Rekulapally |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write a macro to club data in multiple excel workbooks into a signle one???
For code see Ron de Bruin's site.
http://www.rondebruin.nl/tips.htm Scroll down to "Copy/Paste/Merge Examples" and browse through the listings. Gord Dibben MS Excel MVP On Tue, 3 May 2011 16:51:50 -0700 (PDT), dinesh rekulapally wrote: Hi... I want to write a macro to club similar data present in different work books into a single work book. This macro should be dynamic in itself means that if I'm varying the number of rows (because of increase or decrease in data next time) in these individual worksbooks when I run the macro then it should be able to take these total number of rows into the new work book. Please help me in either writing a macro for this kind of problem or with a source code. Thanks and Regards, Dinesh Rekulapally |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to write macro to combine data in multiple tabs into a single tab. | Excel Programming | |||
| Macro to read and write data to multiple sheets | Excel Programming | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| Help with Macro (copying data from multiple workbooks) | Excel Discussion (Misc queries) | |||
Linear Mode
