It's a Copy-Paste World

"In nature, nothing is created,nothing is destroyed.Everything is transformed"

What the french chemist, Antoine-Laurent de Lavoisier, said long time ago could easily be applied to many current issues.Whether you're at the school, at the office, or just trying to show some data to your neighbours about how strong would be the FREE-RIDER effect of that firework party... well, in the end, it's always about a Powerpoit presentation whose data comes from an Excel Sheet......

Thinking about that, I tried to make the life of some of us a little bit easier by adding some automation in the interaction of those applications. The following excel sheet contains a macro which runs a "copy-paste routine" with selected charts and ranges of data from excel sheets to a new powerpoint presentation. For each set of data (ranges and charts), the macro creates a new ppt slide and copy them.

(ENGLISH VERSION)

http://rapidshare.com/files/238383355/XLSPPT_EN.xls.html

(PORTUGUESE VERSION)

http://rapidshare.com/files/238383245/XLSPPT_PT.xls.html

To run the macro press CTRL+a. As you will see, the rows 10-14 are the sample range where u can add and delete the data that will be pasted at the ppt thru the macro. The default sheet contains 20 sets of data, therefore, if you press ctrl+a it should create 20 new slides with the respective data (copied as image).

3 things to keep in mind :

1) enable macros at your sheet;

2) row 10 must be a number -it's a header and its data must be a crescent integer - 1, 2, 3 and so on....-

3) if your excel is in english use XLSPPT_EN ... if it's in Portuguese, use XLSPPT_PT

Last but not least.. VLOOKUP, MAX and MIN are the key functions to let the macro do the work!

Well, is there any easier way to do it? Let me know about it!