EXCEL & Power point MACROSClosed

Question

Hello, 

I am wanting to create a macro, if possible, that will pull only certain data from one worksheet that i get daily and paste that data on another worksheet in a different format. Is there any way to do this. 

Also trying to create a MACRO for powerpoint. I have a folder for each person that has a slide for a brief and they have their own slide in each folder. Currently, Once they have updated there slide i have to manually copy and paste onto a master slide deck for the briefing. I would like a macro that would pull their slide and put them into the master slide deck in the order i want them. Not sure if either of these is possible. I have just found out about macros and want to learn. 


Configuration: Windows 7 / Internet Explorer 8.0

rizvisa1 · Answer

For your first part of question, yes it is very do able. You can get a good starting template by starting macro recorder of excel, then doing what you plan to do manually once and then stop the macro. It would give you a template that you can work from. I think same holds true for your 2nd part of question

avi · Answer

EzPaste (www.ezpaste.net) for completely automating the copy/paste from excel to powerpoint. Hundreds of charts and tables copied AT ONCE

Avi

EXCEL & Power point MACROS

2 responses

Similar discussions

Subscribe To Our Newsletter!