VBA to import sheets with same

[vanitarathod]

Hi all,

I want VBA Code to import multiple sheets bearing same name one below the other which are in different workbooks.

Drive "D" contains "ALL DATA" folder which contains multiple workbook and all workbook contains sheet named "fair"
Can anybody help?

thanks in advance

[apo]

One way..

* Put all Workbooks in "ALL DATA" folder into an array
* Loop through this array and copy range from "fair" sheet in each Workbook to 'result' sheet in a Master Workbook..


Is that enough to send you on your way?.. or do you need the code written for you?

If so.. what's the range that is used in these "fair" sheets..? a sample Workbook would be helpful..

[vanitarathod]

Hi apo,

thanks for reply.

I am new to VBA. Actually I need code for above requirement. I have done small project for excel automation. Based on this automation, I want to import multiple sheets in master workbook for further requirement.

I want to import all cells from sheet starting from Cell A1 till last data in sheet.

Ones again I will mention my requirement.
D drive has folder " ALL DATA" and folder has multiple workbooks where in all workbooks have common named sheet called "FAIR".
I want all the data from fair sheet from 1st cell to last to be imported in active workbook.

Please help.

Thanks in advance

[HaHoBe]

Hi, vanitarathod,

maybe have a look at WBs to 1 Sheet and see if this code may help with your request.

Ciao,
Holger