Excel automation using data from SQL database
Budget: $60 – $100 USD
I have an excel spreadsheet that connects to a database using Power Query. The main table that is pulled in consists of project data which is typically a list of tasks associated with each project and a value associated with each month.
I would like help with the following:
- Using the list of projects from the database, automate the creation of excel sheets so that there is one sheet per project number.
- Each sheet uses the same template. With project tasks as the rows, dates going across the top as columns and then the values within the body.
- Each project has a different number of tasks, so the solution should provide a dynamic way of updating the number of rows and using the sheet name (project number) as the filter on the data (or some similar method that provides the same result)
- Ideally I don't want a pivot table but another way of bringing data dynamically into each sheet
Please let me know you proposal and suggestions
I would like help with the following:
- Using the list of projects from the database, automate the creation of excel sheets so that there is one sheet per project number.
- Each sheet uses the same template. With project tasks as the rows, dates going across the top as columns and then the values within the body.
- Each project has a different number of tasks, so the solution should provide a dynamic way of updating the number of rows and using the sheet name (project number) as the filter on the data (or some similar method that provides the same result)
- Ideally I don't want a pivot table but another way of bringing data dynamically into each sheet
Please let me know you proposal and suggestions