Copy double-clicked cell to next empty row in different sheet with each double-click

Hi,

Here is a working version of what I think you want. Please take a look at the changes I made to the VBA and see if it is what you are asking for.

Notes:
1. The vendor name is now in a named range called "VendorName" - this is important as it is being used in VBA
2. The cell that says "Shipping" is now in a named range called "Shipping" - this is important as it is being used in VBA
3. The formula that calculates the total value of the PO has changed now - this is important as the sum range is variable if you are constantly adding rows to the order form

Let me know if this is what you are after.