Master-Child Excel Sync Expert Needed
Budget: £10 – £20 GBP
I am seeking an Excel expert who can create a master Excel file and a child file with limited columns. The key requirement is that both files need to be synchronized, ensuring that any changes made in one file are automatically reflected in the other.
Key Tasks:
- Create a master Excel file with specified columns (details will be provided)
- Create a child Excel file with limited columns
- Set up synchronization between the two files
- Use IF formula where necessary to ensure smooth functionality
Ideal Skills:
- Proficient in Microsoft Excel
- Experience with IF formula and other Excel functions
- Ability to create and manage linked files
- Detail-oriented to ensure accurate synchronization
The synchronization should be triggered by any of the following changes:
- Adding new rows
- Updating existing data
- Deleting rows
Please note, any change made to the child file should reflect in the master file. The successful completion of this project will greatly simplify my data management process.
Key Tasks:
- Create a master Excel file with specified columns (details will be provided)
- Create a child Excel file with limited columns
- Set up synchronization between the two files
- Use IF formula where necessary to ensure smooth functionality
Ideal Skills:
- Proficient in Microsoft Excel
- Experience with IF formula and other Excel functions
- Ability to create and manage linked files
- Detail-oriented to ensure accurate synchronization
The synchronization should be triggered by any of the following changes:
- Adding new rows
- Updating existing data
- Deleting rows
Please note, any change made to the child file should reflect in the master file. The successful completion of this project will greatly simplify my data management process.