I have an excel file which acts as a benefit calculator. Each time we use it for a customer, we need to manually copy the results of (30 fields) of data into a powerpoint sales pack template that is then printed to PDF and sent to the customer.
Due to the volume of transactions, my boss has tasked me with investigating the possibility of automating the entire process.
I have enclosed two sample files to help with this question:
1. Input file - This is the excel file and I have placed values in two locations. The values are what is needed to be exported to powerpoint. I have also created a command button to execute the upload process.
2. Output file - this is the powerpoint file with two labels named label1 and label2.
Is it possible for someone to help me achieve this from start to finish?