Hi,

I have lots of Excel files which containing data needed to be import in single Excel format.

Is there any way to to import particular cell data to a given format.

I have attached two sample files, 1st one contains Data & 2nd file contains excel format. (I have filed and marked those cells with similar colors in both files
which cells data need to be import.)

Please any one suggest what to do i have around 1500+ files from which data need to be import.

any VB script which import data directly from selected folder.

Thanks

AatifSample Excel Format.xlsxSample - SIDHI 22019589.xls