Excel Automation for Text Reports
Publicada el 2026-08-01
Descripción de la oferta
I have an existing workbook where colleagues paste blocks of free-form text. I now need that same file to recognise the text as soon as it lands, organise it behind the scenes, and then present two clear outputs: • A set of neatly formatted reports (print-ready and easy on the eyes) • Concise summary tables that can be filtered or copied elsewhere Because the input will never be numbers or fixed columns—only unstructured text—the solution will probably rely on smart formulas, Power Query transformations, or a light VBA routine. Whatever method you choose, the end result should be a single workbook that: – Requires no add-ins for the user – Refreshes the reports and tables with one click or automatically on paste – Preserves the original raw text on a separate sheet for reference Deliverables 1. The updated Excel file, fully functioning 2. A short walkthrough (video or PDF) so my non-technical teammates know exactly where to paste the text and where to find the reports If something in my description is unclear just let me know; I can provide a dummy file with sample text to speed things up.
Skills
Fuente original: freelancer