Excel Formatting / Formula Creation 12hr turn around

PLEASE DO NOT APPLY IF YOU CANNOT TURN AROUND IN 12 HOURS

This project involves streamlining and reformatting an Excel workbook with multiple sheets containing product information. The workbook needs to undergo data consolidation and formula refinement to improve usability. Specifically, the various tabs holding cabinet, fiber, containment and cabling records must each be compiled into single sheets labeled appropriately.

Once the raw data across sheets is merged into discreet product tabs, interactive elements will be added. Selecting an item on the individual sheets should auto-populate related fields on summary tabs for materials and estimates. All formulas will be double-checked to ensure accurate carryover of values between sheets upon selection of products or materials.

The end goal is a clean, consolidated workbook functioning as a catalog and estimator. Users will be able to select products and have attendant details and pricing calculators update in real-time on summary pages. Careful reorganization of data and formulas will transform a disjointed multi-tab workbook into a cohesive interface streamlining materials selection and cost estimation workflows. Candidates experienced with Excel data management, formula building and automation are encouraged to apply.