hellojacob
New Member
- Joined
- Nov 24, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Good day all,
I'm new to Google sheets and excel in general. I have a little problem, which I think might be too complex to automate, so it might be a long shot, but if someone has a solution to it, I would greatly appreciate it.
Currently, I have daily auto generated reports that is uploaded to a drive and named in the format "ddmyy_orders". So for example, on 24 november 2020, it would be named "241120_orders" and if it were the following day, it would be named "251120_orders".
What I want to do is have a program or macro help automatically extract data daily from these sheets and compile it into a master sheet.
So basically, on 24 Nov 2020, the program will search for "241120_orders" and extract the data and paste it on the next active row in the master sheet, and on 25 Nov 2020, it will search for "251120_orders" and do the same. Hopefully this will repeat daily and the entire process is automated.
Can this be done? Or is it too complex?
Regards,
Jacob
I'm new to Google sheets and excel in general. I have a little problem, which I think might be too complex to automate, so it might be a long shot, but if someone has a solution to it, I would greatly appreciate it.
Currently, I have daily auto generated reports that is uploaded to a drive and named in the format "ddmyy_orders". So for example, on 24 november 2020, it would be named "241120_orders" and if it were the following day, it would be named "251120_orders".
What I want to do is have a program or macro help automatically extract data daily from these sheets and compile it into a master sheet.
So basically, on 24 Nov 2020, the program will search for "241120_orders" and extract the data and paste it on the next active row in the master sheet, and on 25 Nov 2020, it will search for "251120_orders" and do the same. Hopefully this will repeat daily and the entire process is automated.
Can this be done? Or is it too complex?
Regards,
Jacob
