HELP, dont know how to describe this in a subject line

[samccune]

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?

 

[Myrna Larson]

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.