Hi and thanks for your help on this. For the most part all descriptions are in column "A" in the "Boats", "Options" & "Motors" section. In D93 is where I need the Boat description to go, B94 is where I need the Options description to go and B98 is where I need the "Motor" description to go. All of this is predicated on where the "1" is put in "QTY" C4 thru C39 for the "Boat" section. "QTY" F55 thru F67 for the "Options" section and "QTY" F69 thru F75 for the "Motors" section. Once a "1" is placed in any of the "QTY" for all three areas a price appears next to it and also down the invoice area. I hope I did not confuse you too much on this.
BTW, The options area may be multiple "QTY" selections which will result in a total price for all in the invoice but would require multiple descriptions imported.
Bookmarks