Getting data out from Excel File into PowerPoint (Linked in)

[Aryan Sharifi]

Hey guys.

in our office we're trying organize client's information and create monthlyreports for our clients from an excel data that we receive and we want to insert that info into powerpoint and create a PDF file and send it away. the problem is we're an architectural company and we hardly ever use excel orpower point and I'm wondering if anyone over knows the quickest way to organize this.

e.g.: if we want to create a charts, based on values in date (under Downloaded at: Column & Model Brand lets say in this month we have had this manydownloads from this brand.

or

creating a table mentioning the most number of products downloaded in that month (this will be the number of times the ModelName: names was repeated)

is it possible to do this easily for 120 clients? that'll be 6000 - 9000 data we have to go through and the numbers will only grow?

For some reason I couldn't upload onto the website. could you please check the file from the link below?

http://www.fileconvoy.com/dfl.php?id=g9bd396405268f8049992524373e96a22bf0e26260

Thanks in advance

 

[Puppet_Sock]

in our office we're trying organize client's information and create monthly reports for our clients from an excel data that we receive and we want to insert that info into powerpoint and create a PDF file and send it away. the problem is we're an architectural company and we hardly ever use excel or power point and I'm wondering if anyone over knows the quickest way to organize this.

e.g.: if we want to create a charts, based on values in date (under Downloaded at: Column & Model Brand lets say in this month we have had this many downloads from this brand.

or

creating a table mentioning the most number of products downloaded in that month (this will be the number of times the ModelName: names was repeated)

is it possible to do this easily for 120 clients? that'll be 6000 - 9000 data we have to go through and the numbers will only grow?

Not sure why you need to involve PowerPoint. It seems like you
want to produce some charts and send them to clients. How does
PP help you?

There are print-to-PDF printer drivers. For example. You set up
the charts you want and print them to PDF. It's pretty simple to
make a VB routine that prints the charts you want.

If you absolutely must have your charts in PowerPoint, then you
can paste links to the Excel charts into the PP file. Then
updating the Excel chart will update the PowerPoint file.
Socks