Multi-Currency Quote Sheet Revamp

Customer: AI | Published: 30.12.2025
Бюджет: 250 $

My Excel workbook already builds quotes when I enter a STYLE code and press “Calculate,” but the Quote sheet is hard-wired to pull prices from Sheet1, Column E. I need that lookup to become dynamic so I can switch, one at a time, among the other price columns—H (USD), I (EURO), J, K, L, or M—without rewriting formulas every time. The finished file should let me: • choose the desired price column through a simple control (drop-down, option buttons, toggle, or comparable method); • keep the existing STYLE-to-size workflow intact; • see all totals update automatically once the column is switched; • preserve current formatting and any downstream calculations. I’m fine if you update the current sheet or build a clean template that accomplishes the same goal, as long as it remains easy for me to maintain. Deliverable: updated workbook plus brief, clear notes showing how to change the active price column. When you respond, please include a short, detailed proposal explaining the technique you’ll use—INDEX/MATCH with INDIRECT, named ranges, Power Query, lightweight VBA, or another approach—and your expected turnaround time.