Weekly Sales Data Excel Updates

I maintain a master Excel workbook that tracks our sales performance, and I need it kept perfectly up-to-date. The data you will work on is strictly sales-related; every week fresh numbers come in and some product attributes change, so accuracy and consistency are critical.

Your core focus is twofold:
• Product details – correcting SKUs, names, categories or price changes the moment I provide them.
• Sales figures – inserting the latest weekly totals, making sure formulas, subtotals and running summaries continue to calculate correctly.

I’ll supply the raw export each week. You’ll clean it, paste or import it into the existing sheet, verify that look-ups, conditional formatting, pivot tables and charts still function, then return the finished file ready for Monday reports. If something looks off, I expect you to flag it before finalising.

Deliverable each week: the updated Excel workbook and a brief note outlining any anomalies spotted or assumptions made.

If you’re comfortable with Excel functions such as VLOOKUP/XLOOKUP, SUMIFS, pivot tables and simple VBA for repetitive steps, this will be straightforward. Accuracy beats speed, but I do need the file back within 24 hours of receiving the data.