VBA Macro for Excel Data Sync
Budget: $30 – $250 CAD
I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant.
Key Requirements:
- Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1.
- The macro should prompt for confirmation before updating Tab 2.
- All fields in Tab 1 should be completed before the update.
- The macro should not overwrite existing rows in Tab 2.
Ideal Skills:
- Proficient in VBA programming.
- Excellent understanding of Excel macros.
- Able to create intuitive and user-friendly macros.
This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please include examples of similar projects you've completed in your bid.
Key Requirements:
- Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1.
- The macro should prompt for confirmation before updating Tab 2.
- All fields in Tab 1 should be completed before the update.
- The macro should not overwrite existing rows in Tab 2.
Ideal Skills:
- Proficient in VBA programming.
- Excellent understanding of Excel macros.
- Able to create intuitive and user-friendly macros.
This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please include examples of similar projects you've completed in your bid.