Greetings everyone,
Daily i receive 6 different xls/xlsx files. Those files contain data in certain cells (always in fixed positions) which i need to compare with data of a 7th xls file (again in fixed positions). The files always have same names as 1.xls, 2.xlsx, 3.xlsx, 4.xls, 5.xlsx, 6.xlsx. Although, the file end may vary from xls to xlsx and folder name is not the same, but all files are in the same folder every time. Thats it, i just need to import the data of those files to the 7th file and then simply subtract to ensure that there is not a value difference. To be more specific, i need to import:
1) from 1.xls sheet (Bankstanden) cells (M15, N9) placed on cells (V5, W5) respectively,
2) from 2.xlsx sheet (summary) cells (B8, D8, C8, B7, D7, B7) placed on (V11, V12, V13, W11, W12, W13) respectively,
3) from 3.xlsx sheet (0317) cells (H13, H26, H37, H51, H57, H63) placed on (Y26, Y27, Y28, Y31, Y32, Y33) respectively,
4) from 4.xls sheet (CASH MS FRANCE) cells (B45, H34) placed on (AD5, AD11) respectively,
5) from 5.xls sheet (0767) cells (E9/1000, E10/1000) placed on (V14, Z14) respectively,
6) from 6.xlsx sheet (Russia_Lithuania) cells (R5, R4) placed on (Y34, Y35 respectively,
since i am new to VBA and macros i am in a major struggle to find the solution which i need for my job. If you could provide me the code i would really appreciate it! Thank you!
Bookmarks