Dear All I am creating a dashboard to display data to senior managers on how we are performing at any one time. The vechicle used to display this data has to be easily accessible, free and only to be controlled by me (a non-IT person!). Therefore, powerpoint has been selected as the vechicle to display the finished result.
The original data is input into a system called Performance Plus (written by InPhase) by several colleagues across the company. I am able to extract this data into a very nastily formatted excel spreadsheet (Merged cells un-necessarily, text boxes all over the place and random blank fields and rows). What I need to be able to do is somehow automatically format the nasty spreadsheet and link it to another excel spreadsheet where calculations are coded in to determine performance. This second spreadsheet (nicknamed the "master") will then need to be linked to powerpoint. Currently, i have completed the second phase and have the master spreadsheet completed by manually writing in all the data (i.e. not linking to the nasty spreadsheet from Performance Plus). The master spreadsheet works everything out but then I have to physically copy every bit of data, table and chart into the powerpoint presentation (and there is tons of it!) Is there any way I can: a) Automatically format the 1st nasty spreadsheet and link it to my nicely formated one so that each week i can export a new ssheet from performance plus and call it the same file name so my master spreadsheet automatically updates to the latest copy of performance plus (the usual copy and paste link method doesnt work correctly - it pastes a text box linked to the first ssheet instead of pasting the value into the designated cell, meaning i cant do any formulars with it because its just a text box and not a cell value). b) Link my completed charts and tables to powerpoint quickly and easily, without having to copy and paste each one in. Any help appreciated - i hope this makes sense to some one out there!! Kind Regards Laura --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
