Hi Everyone,

I'm currently working on a program that will allow me to create a presentation. The idea is to have a "menu" on the first sheet that lists multiple pieces of equipment, then be able to select the pieces that I want and then be able to hit a macro button that will take those selections and create a presentation out of it. On Sheet 1 I have each piece of equipment listed in their own cells in column B. On Sheet 2 I have pasted in word documents that relate to each piece of equipment. The goal is to be able to go down the list on Sheet 1 and select only the pieces that are needed. For this I thought to just go down and put a "1" in column C, in the Row that has the equipment I want. Lets say I need a Deep Fryer and that is in cell B12. So I would go down and in cell C12 I would put a "1" and that would indicate that piece of equipment is needed. After going down and selecting the equipment needed, I'd like to set up a macro button that will recognize the rows that have a "1" in column C and be able to produce a shortened list of only the equipment I am in need of. Based off this list I also want the macro button to then produce the word document on Sheet 2 that corresponds to the pieces of equipment selected, and I want these to be produced onto Sheet 3. The goal then is to export these selected documents and then import them into a word doc. or a pdf, so I then have a nice presentation of the desired equipment needed for the job. I'm dealing with hundreds of pieces of equipment.

If anyone could help I would really appreciate it, and if there are any steps you think are un-needed feel free to make it your own, but explain what you cut out and how you got around it.

Thanks!