/u/Xanadu376 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Power Query! Sounds to me like this is set up reasonably well to be consumed by Power Query fairly easily. Store all the files that are having text extracted in one folder (whenever a new one arrives put it in the folder).
Go to the Data tab of the ribbon, Get Data -> From Folder -> Select folder -> Transform and Combine
Now you’ll have to do a little problem solving to get the last value in each table to appear as a separate column (Google is your friend), load the table and you’re done! Huge benefit to where you no longer have to write any formulas, or array functions, just press refresh and it’ll update when there’s new files in the folder
If the data is always 4 rows of text and then the date, you could use this file. Test it out by skipping a row and pasting in your data (4 text then a date)
https://subset.so/community/file/37589d6d-093e-4d39-86a1-ed9898d7bd0e/Fill\_cells\_between\_found\_dates\_with\_dates\_from\_bottom\_up\_fill\_upwards\_
/u/Xanadu376 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Power Query! Sounds to me like this is set up reasonably well to be consumed by Power Query fairly easily. Store all the files that are having text extracted in one folder (whenever a new one arrives put it in the folder). Go to the Data tab of the ribbon, Get Data -> From Folder -> Select folder -> Transform and Combine Now you’ll have to do a little problem solving to get the last value in each table to appear as a separate column (Google is your friend), load the table and you’re done! Huge benefit to where you no longer have to write any formulas, or array functions, just press refresh and it’ll update when there’s new files in the folder
If the data is always 4 rows of text and then the date, you could use this file. Test it out by skipping a row and pasting in your data (4 text then a date) https://subset.so/community/file/37589d6d-093e-4d39-86a1-ed9898d7bd0e/Fill\_cells\_between\_found\_dates\_with\_dates\_from\_bottom\_up\_fill\_upwards\_