Excel Workbook: Dynamic Data Consolidation
Budget: ₹1,500 – ₹12,500 INR
I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change.
PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING.
Key requirements:
- Use either Excel formulas or Power Query. VBA and Macros are not allowed.
- Summarize totals for each unique combination of columns A-D from the source sheets.
Note :
data both sheets could go up to 1000 + rows.
Deliverables:
- A fully functional Excel file where the main sheet updates in real-time.
- Clear documentation or a short instructional guide explaining how the solution works.
Ideal skills and experience:
- Strong Excel skills and expertise in using Power Query.
- Good understanding of data mapping.
- Prior experience with creating dynamic Excel solutions is highly advantageous.
PLEASE NOTE I WILL NOT EXTEND THE AMOUNT OF BID; SO ONLY BID WHAT YOU WANT.
Thanks
PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING.
Key requirements:
- Use either Excel formulas or Power Query. VBA and Macros are not allowed.
- Summarize totals for each unique combination of columns A-D from the source sheets.
Note :
data both sheets could go up to 1000 + rows.
Deliverables:
- A fully functional Excel file where the main sheet updates in real-time.
- Clear documentation or a short instructional guide explaining how the solution works.
Ideal skills and experience:
- Strong Excel skills and expertise in using Power Query.
- Good understanding of data mapping.
- Prior experience with creating dynamic Excel solutions is highly advantageous.
PLEASE NOTE I WILL NOT EXTEND THE AMOUNT OF BID; SO ONLY BID WHAT YOU WANT.
Thanks