▲ 4 r/ExcelTips
Title: Reporting automation to combine 12 csv files every week
​
Body: I download 12 csv exports from different tools. Sales, ads, support, shipping. I open each one, clean headers, vlookup into a master sheet, build a pivot, then paste into PowerPoint.
It is 2 hours of manual work and I always worry I pasted the wrong week. Power query breaks when a vendor changes a column name. I do not have power BI budget. I just need something that ingests the files, standardizes them, and spits out the slide with the updated chart. How do you make this truly hands off?
u/davidmaich — 2 days ago