vba to export data from single wb along with existing 2 sheet!!

Dear experts

I have N number of multiple closed workbooks in desired path with sheet list like A,B,C...etc

i want vba to export data from single closed workbook sheets Acc&Sub acc depends upon unique value of H:H column of closed workbooks A,B,...etc
along with existing sheets FY-15 & FY-16

for e.g In workbook A sheet(List) H:H column Unique values are TE001, & TE002. I want export TE001&TE002 from Datafile.wb Acc&Sub acc sheet.
at end copy FY15 & 16 sheet to all workbook.

In workbook B sheet(List) H:H column Unique values are TE001,TE003&TE004. I want export TE001,TE003,TE004 from Datafile.wb Acc&Sub acc sheet.
at end copy FY15 & 16 sheet to all workbook.


find the attachment.. You may understand. i want run macro in blankworkbook.
A,B,C....Files stored in C:\Users\Julie\Desktop\FY16
DataFile stored in C:\Users\Julie\Desktop\Data

Hi John

I can only hope your not running on a Mac Platform.

Place the attached Code Book anywhere you please. Change the Paths as required. tgtPath is the Path where your A, B, C, etc files are located. srcPath is where the Datafile.xlsb is located.

Please Login or Register  to view this content.

Please Login or Register  to view this content.