Hi all,
I ultimately want to have one worksheet embedded in slide 1 of a powerpoint and another worksheet embedded in slide 2. Problem is that I want to do something like A1 of worksheet1 = A2 + B5 of worksheet 2.
The way I have it set up right now is that there's one workbook in slide 1 and one workbook in slide 2. I double click on the workbook in slide 1 and start to put in the equation, but once I try to select the workbook on slide 2, it jumps out and never finishes.
I was wondering if there's an easy way to "link" cells between workbooks in excel. I'm not sure if that's possible or not. A solution that may work is if I can create one workbook, but somehow have it show up on both slides...that way I can reference within the workbook. I also want the values to change as I enter information, because I have to update the worksheets all the time. Linking instead of embedding the excel sheet is not an option, because I want a standalone .ppt with all the information I need.
Is it possible to do this using VB scripts? I'm not familiar with any of that, so if anyone can step me through, I would greatly appreciate it.
I ultimately want to have one worksheet embedded in slide 1 of a powerpoint and another worksheet embedded in slide 2. Problem is that I want to do something like A1 of worksheet1 = A2 + B5 of worksheet 2.
The way I have it set up right now is that there's one workbook in slide 1 and one workbook in slide 2. I double click on the workbook in slide 1 and start to put in the equation, but once I try to select the workbook on slide 2, it jumps out and never finishes.
I was wondering if there's an easy way to "link" cells between workbooks in excel. I'm not sure if that's possible or not. A solution that may work is if I can create one workbook, but somehow have it show up on both slides...that way I can reference within the workbook. I also want the values to change as I enter information, because I have to update the worksheets all the time. Linking instead of embedding the excel sheet is not an option, because I want a standalone .ppt with all the information I need.
Is it possible to do this using VB scripts? I'm not familiar with any of that, so if anyone can step me through, I would greatly appreciate it.
I still haven't figured it out yet. Please help!
