I need help creating a macro. I need it to look at my cities and go into a directory in a shared drive and look up the folders for those cities and look in a folder called "2016", then look for the current months file and in it look in the tab called "Summary" and report back if they filled out info for that day.
For instance, I have attached two files. One is the Report file which is where I want to run the macro from. The other is the Log file which is where my cities will log their info. From here i need it to look at the city on column A on my Report file, go to the shared drive location (i.e. C\path1\path2\"city") and in there find a folder called "2016" (this folder "2016" will be the same in all cities). This folder has 12 Log files, one for each month labeled "1 Jan Log", "2 Feb Log", "3 Mar Log" ..etc. In these Log files, there is a summary tab which is where I want it to look and see if they completed the log for that day. The total on row 13 for that respective day will have something other than 0 if it was completed, which i want it to return that on my Report file under the column for that day for that city. Hope this makes sense.
Any help is greatly appreciated!