If I have a bunch of Excel sheets in a folder and all contain same data except it gets updated every month with same name ending with month & year.
Instead of reading exact file with its name using
Is there a tidyverse way that file ending with latest year & month gets picked up without specifying the full file name?
It would also be great to know, if we had different names all together, but just based on latest updated date, we can read the latest file regardless of its name.
Thanks for the help!