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.
[TABLE="class: grid, width: 200"]
<TBODY>[TR]
[TD]AAA
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]-----
[/TD]
[TD]-----
[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]-----
[/TD]
[TD]-----
[/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
</TBODY>[/TABLE]
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.
[TABLE="class: grid, width: 200"]
<TBODY>[TR]
[TD]AAA
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]-----
[/TD]
[TD]-----
[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]-----
[/TD]
[TD]-----
[/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]data
[/TD]
[/TR]
[TR]
[TD]data
[/TD]
[TD]data
[/TD]
[/TR]
</TBODY>[/TABLE]