I am trying to create an invoice workbook. One spreadsheet will have all our
stock on with its relevent prices next to it, and the other will have a
invoice template on its spreadsheet. What i am trying to work out, is how to
create a function (similar to an 'add-to-basket' function on a shopping
website) that i can click add-to-invoice an item of stock with its quantity
and relative price, in the three seperate cells of the invoice spreadsheet.
Can anyone point me in the right direction in designing this in excel?