I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows:
- One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements.
- Data Type: The primary data being used in these sheets is a combination of text and numbers.
Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorably if you can provide examples of similar projects you've completed successfully.
Part of this job is to provide a recording of and explanation (no longer than 3 mins screen video) explaining how to link sheets for the future