I've been playing with this and realize what my issue is, the Y/N is picked from a pull down on another worksheet "DATA_INPUT" and looks like this

Formula: copy to clipboard 
=Data_Input!B18


The worksheet "QUOTE" which I have the macro assigned to is a completely generated sheet with no input on it, it is simply a results page. I guess my question now is what do I need to change in order to allow this macro to work with a result from another worksheet?