data-extraction-sync

What problem does it solve?

This skill tackles the challenge of pulling data from non-standard Excel layouts and keeping related worksheets in sync across workbooks. It provides structured patterns to interpret visual or matrix-like layouts, detect changes, and propagate updates safely.

Core Features & Use Cases

• Structured Data Types: Define reliable data structures for records, changes, and extraction results to enable robust synchronization.
• Complex Layout Extraction: Map visual layouts (whiteboards, calendars, matrices) to structured data across multiple sheets.
• Change Detection & Propagation: Identify differences between source and target and apply updates with validation and optional rollback.
• Bidirectional Synchronization: Maintain consistency between related sheets regardless of where edits occur.
• Use Case: Manage a workbook where upcoming items, statuses, and orders must stay aligned between a whiteboard-like sheet and its detail rows.

Quick Start

Enable macros in Excel and open the workbook containing Upcoming Packs and WHITE BOARD. Run the UpdateWhiteboardFromUpcoming macro to load data, detect changes, validate rules, and apply updates to keep sheets synchronized.