I´m building a sheet to work as a database but I have to collect data from a lot of excel .xls organized in folders like YEAR/MONTH and the file´s name is XXXXX_ddmm.xls for 16 different operation sites (the XXXXX directs to each one). This is from january first 2018 until today´s files.
Inside each file I have to copy the information at C9:R9 an paste data to match destination format.
The place I want to use as database is one sheet that I'm going to use each line to the specific date from that unit. I will have 16 sheets, one for each operational site.
Flow I'm seeking is open file XXXXX_0101 from folder 2018/January > activate sheet PRP > copy C9:R9 > close file > activate database YYYYY sheet XXXXX > search 01/01/2018 > paste only data > XXXXX_0102 from folder 2018/January > activate sheet PRP > copy C9:R9 > close file > activate database XXXXX > search 01/02/2018 paste (...) this goes in loop until yeasterday's file
Can you help me? I´m stuck with the code!!
I tried to record something from macros at excel but it's not helping to build that.
