Excel Macro - to import data from multiple Excel files from certain cells

Vote count:

0

Please could someone help me on the below query? Daily I receive 3 different files via e-mail and i need these xls file data on to one Workbook. the layout of each file is different, however daily received files will be in the same format, only different will is current days date is added to the xls file. File 1 name is : BlankApp_yyyymmdd.xls / File 2 name is : DisRep_yyyymmdd.xls / File 3 name is : PerApp_yyyymmdd.xls

from File 1, i need data from B2, A7, D11, G11 (Single row) from File 2, i need data from A7, C8, E9, H9 (Single row), A11, C12, E13, H13 (single row), A15, C16, E17, H17 (single row) & A19, C20, E21, H21 (single row) from File 3, i need data from B2, A7, D11, G11 (single row)

In summary daily i need about 6 rows data on to my Workbook, which should accumulate on a daily basis. Please help.

asked 2 mins ago

satya

1

Excel Macro - to import data from multiple Excel files from certain cells