I've been trying to create a system for taking orders for products that I sell. Basically I have created a sheet with products and a column in which you can type in the number of products being ordered. This then calculates the prices etc. that all works grand. I am having trouble though when I am trying to create an automatic delivery note in another sheet. I want the sheet to automatically fill out the product name and the number but only of the products ordered.
I believe I can do this using nested IF functions but I feel there must be a much easier was to do it as I plan on bringing in much bigger numbers of products.
Can anyone be any help? Cheers
I have attached the sheets as I have them now.
Bookmarks