Could someone tell me how i would make a cell so when i put a figure (amount
needed of an item) in it, it will automatically copy the info from a row of
cells over to another sheet as well as multiplying one of those cells by the
figure i entered.
eg, after picking the items i need and the amount from one sheet i will end
up with and order form on another with the cost.
Any help would be appreciated.