Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP, dont know how to describe this in a subject line
Ok so here's the deal. I have a powerpoint presentation... well actuall its just a flyer. In it I have 4 embedded Excel worksheets shown below They are actually just a few cells of the worksheets refering to a external sheet. The question is, is there away that i can open th existing powerpoint file and by changing the value of one cell... mak it change all of the "7"s to say... "8"s. Embedded WS #1 ='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$7 Embedded WS #2 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 Embedded WS #3 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$7 ='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$E7 Embedded WS #4 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$G$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$H$7 my thought on how to do this, was perhaps to put in one of the empt cells in WS #1 the number 7. Then, call that value into the refernc code. like this kinda... =-'C:\PCS Connection\[Compan Discounts.xls]Sheet1'!$B$((XWS#1-CELLVALUEX)) any ideas? -- samccun ----------------------------------------------------------------------- samccune's Profile: http://www.excelforum.com/member.php...fo&userid=1459 View this thread: http://www.excelforum.com/showthread.php?threadid=26340 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP, dont know how to describe this in a subject line
The formula to do what you want is
=INDIRECT("'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$"&K1) where you put the number 7 in cell K1. On Fri, 24 Sep 2004 21:38:49 -0500, samccune wrote: Ok so here's the deal. I have a powerpoint presentation... well actually its just a flyer. In it I have 4 embedded Excel worksheets shown below. They are actually just a few cells of the worksheets refering to an external sheet. The question is, is there away that i can open the existing powerpoint file and by changing the value of one cell... make it change all of the "7"s to say... "8"s. Embedded WS #1 ='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$7 Embedded WS #2 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 Embedded WS #3 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$7 ='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$E7 Embedded WS #4 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$G$7 =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$H$7 my thought on how to do this, was perhaps to put in one of the empty cells in WS #1 the number 7. Then, call that value into the refernce code. like this kinda... =-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$((XWS#1-CELLVALUEX)) any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time in subject line | Excel Discussion (Misc queries) | |||
Customize Subject Line | Excel Discussion (Misc queries) | |||
Populate the subject line. | Excel Worksheet Functions | |||
Subject line in outlook | Excel Programming | |||
Subject line in E-mail | Excel Programming |