Get data from another excel files which sit on the server folder, based on the date value in the current excel file.

[a24425311]

Hi guys,

I am still Googling to see if there is a better way to do this.

I have a local excel file and would like to build a VBA code to copy data from an excel file that currently sits on the local server.

Data Fetching Criteria:
Based on the Date (Month) value in cell G2 (sheet1 in local excel), if G2 is 22-Dec-2022, it will look for the folder Dec_2022, copy data from Dec_Record.xlsx and paste data to the local excel (sheet2 in local excel).

Copy Data:
Copying only Colum G, I, J, U, V, W & X and paste multiply (to avoid stored as text error) to the local excel file Colum A, B, C, D, E, F & G

Files path (Server)
Root
|_Sept_2022
|_Sept_Record.xlsx
|_Oct_2022
|_Oct_Record.xlsx
|_Nov_2022
|_Nov_Record.xlsx
|_Dec_2022
|_Dec_Record.xlsx

*These files are constantly updated


Thank you in advanced