dkorobchenko
05-03-2022, 12:19 PM
Dear readers,
I created the profile here today because I’m completely lost with power query. I have some beginner knowledge when it comes to VBA, but this problem just stumped me…
I would appreciate any help or an advice on where can I learn more about this topic
Essentially, what I’m trying to do is: I have a folder with PDF documents, that every morning I name with todays date and giving them a unique identifier (9 files a day) so they would look something like this 04.17.2022 – 0001, 04.17.2022 – 0002, and so on, what I’m trying to do is have these 9 documents import under 1 consolidated table.
To be honest I don’t know if its even possible to have excel find the 9 documents of a given date in a large folder and consolidate them…
Thank you for reading,
Sincerely,
I created the profile here today because I’m completely lost with power query. I have some beginner knowledge when it comes to VBA, but this problem just stumped me…
I would appreciate any help or an advice on where can I learn more about this topic
Essentially, what I’m trying to do is: I have a folder with PDF documents, that every morning I name with todays date and giving them a unique identifier (9 files a day) so they would look something like this 04.17.2022 – 0001, 04.17.2022 – 0002, and so on, what I’m trying to do is have these 9 documents import under 1 consolidated table.
To be honest I don’t know if its even possible to have excel find the 9 documents of a given date in a large folder and consolidate them…
Thank you for reading,
Sincerely,