Build a script
Budget: $30 – $250 USD
I need an r project that:
Opens the latest file .xls from a directory/folder (file will start with the previous date as the title+xxxx
Grabs a number from the one of the rows (most recent) according to the date of the title name
Pastes this number in a different file .xls, in a specific tab matching the date.
So if the first files name is 12/2/2022_File.xls. It will look in this file for the number on a specific column/row with the same date
Then open a new file and look for the row with 12/2/2022 and put it in a specific column matching the row date
Opens the latest file .xls from a directory/folder (file will start with the previous date as the title+xxxx
Grabs a number from the one of the rows (most recent) according to the date of the title name
Pastes this number in a different file .xls, in a specific tab matching the date.
So if the first files name is 12/2/2022_File.xls. It will look in this file for the number on a specific column/row with the same date
Then open a new file and look for the row with 12/2/2022 and put it in a specific column matching the row date