<div>
To understand the flow it looks as though a copy of your PPT presentation that you are modifying would help ... can do?<br />
<br />
Chris
</div>


To understand the flow it looks as though a copy of your PPT presentation that you are modifying would help ... can do?

Chris

test-r1.xlsm

<div>
Thanks for the help and sorry for the delay, was on vacation. &nbsp;I will test it today and let you know. <br />
<br />
Montrof
</div>


Thanks for the help and sorry for the delay, was on vacation.  I will test it today and let you know.

Montrof

<div>
Great work this is exactly what I needed. &nbsp;Thank you for the help.<br />
<br />
Montrof
</div>


Great work this is exactly what I needed.  Thank you for the help.

Montrof

<div>
<div class="content wysiwyg-content">
I am using a macro to copy charts and data tables from Excel to PPT. &nbsp;After that macro runs an additional macro runs to delete slides that we are not using this month. &nbsp;So what I would like to do is Take the Slide Numbers that where deleted (G5:G9) and update the status in the &quot;Update&quot; Column(H) to &quot;No&quot; for the slides that where deleted. Next I need to adjust the &quot;Slide#&quot; Coulmn(I) based on the deleted Slide Numbers. &nbsp;For example if I delete slides 5 and 6 then Slide 7 would now be 5 and slide 8 would now be 6 and so on... &nbsp;I am attaching the file I am using and any help would be greatly appreciated.<br />
<br />
Thanks,<br />
Montrof<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/02_w07/551313/TEST.xlsm" target="_blank" class="file-inline" title="Example (65 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>TEST.xlsm</a>
</div>
</div>


TEST.xlsm

I am using a macro to copy charts and data tables from Excel to PPT.  After that macro runs an additional macro runs to delete slides that we are not using this month.  So what I would like to do is Take the Slide Numbers that where deleted (G5:G9) and update the status in the "Update" Column(H) to "No" for the slides that where deleted. Next I need to adjust the "Slide#" Coulmn(I) based on the deleted Slide Numbers.  For example if I delete slides 5 and 6 then Slide 7 would now be 5 and slide 8 would now be 6 and so on...  I am attaching the file I am using and any help would be greatly appreciated.

Thanks,
Montrof

Update Table based on other macros

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.