Excel Price Sheet Consolidation Expert
Budget: $25 – $50 USD
I have several price sheets in Excel that need to be merged into one reliable source of truth. The work begins with cleaning and organising each file—removing duplicate rows, fixing inconsistent SKU and product name spellings, and aligning column structures—before combining them into a single master workbook.
Once the data is unified, I need it laid out in a clear, standardised structure and enhanced with conditional formatting so key variances (such as cost changes or missing prices) stand out immediately. Feel free to leverage Power Query, advanced formulas, or VBA if it speeds things up; just be sure the final workbook remains easy for a non-technical user to maintain.
Deliverables
• One Excel workbook containing all price data, fully de-duplicated and merged.
• Consistent column order, naming, and data types across every tab.
• Conditional formatting rules that highlight outliers, blanks, and cost variances.
• A brief “read-me” sheet summarising the steps taken and any assumptions made.
Once the data is unified, I need it laid out in a clear, standardised structure and enhanced with conditional formatting so key variances (such as cost changes or missing prices) stand out immediately. Feel free to leverage Power Query, advanced formulas, or VBA if it speeds things up; just be sure the final workbook remains easy for a non-technical user to maintain.
Deliverables
• One Excel workbook containing all price data, fully de-duplicated and merged.
• Consistent column order, naming, and data types across every tab.
• Conditional formatting rules that highlight outliers, blanks, and cost variances.
• A brief “read-me” sheet summarising the steps taken and any assumptions made.