how to write a macro to club data in multiple excel workbooks into asignle one???

  • Thread starter dinesh rekulapally
  • Start date
D

dinesh rekulapally

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Split Workbook into Multiple Workbooks 5
Copying select data frm one workbook to multiple workbooks & save 7
Combine 2 columns in a dynamic range into one 7
How to apply a macro to all workbooks 2
Run code from another workbook 7
Macro to open file and copy information from worksheet 1
Multiple workbooks - NEED HELP 3

Top