Custom Excel Sheet with API Integration
Budget: ₹37,500 – ₹75,000 INR
I need a custom Excel sheet that fetches financial data from a specific API (URL and port will be provided) and summarizes it in an accessible format. The raw data should be stored in a hidden sheet, while the summary is displayed in the main view.
Key Requirements:
- Use of VBA programming for custom functionality
- Integration with a financial API
- Creation of table-based forms within Excel that allow for dynamic row/column addition via a custom button
- Implementation of various data validation checks (data type, range, custom logic)
- Use of dropdowns and other Excel features for data input in the forms
Please include examples of your previous Excel customizations with your proposal. Exact project scope will be provided to qualifying candidates.
Key Requirements:
- Use of VBA programming for custom functionality
- Integration with a financial API
- Creation of table-based forms within Excel that allow for dynamic row/column addition via a custom button
- Implementation of various data validation checks (data type, range, custom logic)
- Use of dropdowns and other Excel features for data input in the forms
Please include examples of your previous Excel customizations with your proposal. Exact project scope will be provided to qualifying candidates.