PDA

View Full Version : NEED VBA Macro



sppraysoft
03-03-2015, 03:34 AM
Hello Friends..

I need a VBA Macro to combine Particular sheet [ unique sheet Name] from multiple Workbooks from a Folder.

sppraysoft
03-03-2015, 03:36 AM
For Example:--

DATA - is the unique sheet names from multiple workbooks. So, I need to combine all "DATA" sheets from multiple workbooks in to single workbook in sheet

Yongle
03-03-2015, 09:02 AM
It is difficult to answer your question without asking you lots of questions also. Sorry to ask so many questions but, here they are:
1 Does every sheet called DATA look the same? What exactly are you trying to combine - numbers? text?
2 What does combine mean - are you wanting at add cells in same position in each sheet or build a table of values, taking information from many workbooks?
3 Do the workbooks have special names, so that it is easy to group them together or do you want to combine every workbook in the folder?

If you post 3 workbooks that you are trying to combine, perhaps we can help you.