Hello Friends..
I need a VBA Macro to combine Particular sheet [ unique sheet Name] from multiple Workbooks from a Folder.
Hello Friends..
I need a VBA Macro to combine Particular sheet [ unique sheet Name] from multiple Workbooks from a Folder.
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
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.