Solutionmatt
New Member
- Joined
- Feb 2, 2022
- Messages
- 16
- Office Version
- 365
- 2021
- Platform
- Windows
| index example.xlsx | |||||||
|---|---|---|---|---|---|---|---|
| D | E | F | G | H | |||
| 3 | NUMBER OF SLIDES IN THIS PRESENTATION | 2 | |||||
| 4 | INCLUDE SLIDE | SLIDE NUMBER | |||||
| 5 | ****TAILS & CANAPéS 1 | 0 | NO | 1 | |||
| 6 | ****TAILS & CANAPéS 2 | 0 | NO | 2 | |||
| 7 | ****TAILS & CANAPéS 3 | 1 | YES | 3 | |||
| 8 | ****TAILS & CANAPéS 4 | 0 | NO | 4 | |||
| 9 | ****TAILS & CANAPéS 5 | 0 | NO | 5 | |||
| 10 | GOURMET BUFFET | 0 | NO | 6 | |||
| 11 | CYPRUS MEZE | 1 | YES | 7 | |||
| 12 | FLAMES BBQ | 0 | NO | 8 | |||
| 13 | EXQUISITE CULINARY JOURNEY | 0 | NO | 9 | |||
Sheet1 | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G3 | G3 | =COUNTIF(G5:G502,"YES") |
| G5:G13 | G5 | =IF(F5=1,"YES","NO") |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| G5:G13 | Cell Value | ="NO" | text | NO |
| G5:G13 | Cell Value | ="YES" | text | NO |
I need help with this, I really want to choose the slides from a .ppt deck if the value is YES and corresponding slide, to then export it as a pdf to my clients...........
this is killing me as i am doing it manually at the moment by filtering the YES's and keeping the corresponding slides!
please if theres anyone out there if they can help me.........
