James Blackbrough
New Member
Hi All,
Hope someone can help as this is driving me nuts. A bit beyond my limited excel skills.
I have created an order form where the customer can select the quantity of items from a drop down box next to the product descriptions. What i'd like to do is have a formula to copy the description cell, the item code cell and the cost cell, for the products the customer requires, onto another sheet to create a pro forma type invoice. I'm not at all experienced in VB but keen to learn.
Hope someone can help.
Thanks,
James
Hope someone can help as this is driving me nuts. A bit beyond my limited excel skills.
I have created an order form where the customer can select the quantity of items from a drop down box next to the product descriptions. What i'd like to do is have a formula to copy the description cell, the item code cell and the cost cell, for the products the customer requires, onto another sheet to create a pro forma type invoice. I'm not at all experienced in VB but keen to learn.
Hope someone can help.
Thanks,
James
Attachments
Last edited: