Hello everybody,
I have an Excel sheet, which lists services. This services can be provided for different customers, this is why there can be more than one entry for customer in a customer cell. In the finished Excel there will be about 30 different customers. First I want something like a Pivot table, where I can filter for customers. So for example I want a table where I can see how many services are offered in the different service areas for the different customers. I can’t use a normal Pivot table for this because of the multiple values in a cell.
Secondly and this is more important, I want to create single PowerPoint slides out of the Excel for a single service, which should update automatically. In the end there will be about 150 services and I want a PowerPoint slide for every service. On this slide there should be the name of the service and the rest of the properties. What I don’t want is to copy the whole Table as one in a Power Point. The system should work like this: There is a change in the properties of one service. Therefore the responsible person changes the property in the Excel cell and the system automatically updates the PowerPoint slide for the service.
If multiple data in one cell is not possible, I thought about creating a Database in Access and then exporting it to Excel. And subsequently creating the PDF’s out of the Excel. In this case the responsible person would change the property in the access database. Multiple data in one cell is no problem for access, but a reporting with Pivot tables would not be possible.
The most important part is to create single PowerPoint slides out of the Excel. I am a complete newbie and the task is rather complex so I would be very grateful for your help
Thanks a lot
Matze
I have an Excel sheet, which lists services. This services can be provided for different customers, this is why there can be more than one entry for customer in a customer cell. In the finished Excel there will be about 30 different customers. First I want something like a Pivot table, where I can filter for customers. So for example I want a table where I can see how many services are offered in the different service areas for the different customers. I can’t use a normal Pivot table for this because of the multiple values in a cell.
Secondly and this is more important, I want to create single PowerPoint slides out of the Excel for a single service, which should update automatically. In the end there will be about 150 services and I want a PowerPoint slide for every service. On this slide there should be the name of the service and the rest of the properties. What I don’t want is to copy the whole Table as one in a Power Point. The system should work like this: There is a change in the properties of one service. Therefore the responsible person changes the property in the Excel cell and the system automatically updates the PowerPoint slide for the service.
If multiple data in one cell is not possible, I thought about creating a Database in Access and then exporting it to Excel. And subsequently creating the PDF’s out of the Excel. In this case the responsible person would change the property in the access database. Multiple data in one cell is no problem for access, but a reporting with Pivot tables would not be possible.
The most important part is to create single PowerPoint slides out of the Excel. I am a complete newbie and the task is rather complex so I would be very grateful for your help
Thanks a lot
Matze