Excel to Powerpoint: dynamic data updating?

Pats2KDynasty

New Member
Joined
Oct 22, 2012
Messages
2
Say I have an excel report that is an output from a web site. This excel sheet may have a different number of records arranged in a different order each time. I am trying to link sections of this data to individual PowerPoint slides.

So in the example below I have a slide for AAA and another for BBB and another for CCC. My source Excel data is outputed all together like below so I link special each data section. My problem comes when GGG gets into my data in between AAA and BBB now my linked slides are off because the slide for BBB shows the linked data for GGG. Is there any way to link data based on data rather than static cells? I cannot do conditional comparing statements because it would be impracticle against 300 records.

AAA
data
data
data
-----
-----
BBB
data
data
data
-----
-----
CCC
data
data
data

<TBODY>
</TBODY>
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,136,780
Messages
5,677,688
Members
419,712
Latest member
LearningCR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top