Forum Discussion
I need some help digitising our paper order system, but struggling with the code!
I have 4 sheets: 1 where we fill out the orders our students place, 1 where we calculate how much we owe the retailer,1 with the price list in case it changes and 1 for students with discount.
Would anyone be able to help with the following?
- Link the items to the price list and the amount ordered. It needs to show correctly in the PRICE column for the item if a student orders 1, 2 or 3 items.
- If DISCOUNT = yes, in the PRICE WITH DISCOUNT column, I need the price to be calculated with an 80% discount
- In the 'order to retailer' tab, I want the excel to see how much of each item is ordered and make a sum of the price WITHOUT discount
- I want the data (student name, total order amount, amount with discount) from the order sheet to automatically go into the discount sheet if I selected 'yes' to discount and also for the amount that was discounted to be be displayed in the 'to be paid by the city' (students with discount only pay 1/5th and the city pays 4/5th)
Please would someone be able to assist?
Thanks a million!!!
2 Replies
You're asking a lot! The least you could do is make the workbook available. Could you attach a sample workbook demonstrating the problem (without sensitive data) to a reply, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Thank you for your reply!
Ahhh I am so sorry, I didn’t realise I’d submitted this without double checking!I have put in all the codes to try and emulate those 4 things (VLOOKUP for the price list, code for populating data from the master in my discount sheet and the order sheet which I have done for previous workbooks and some sums and IFs for the price calculation), but it’s giving lots of #VALUE, which is very frustrating as some of these codes I have used regularly for making financial reports and it’s never failed, just the price list is something I’ve never tried, so I’m not sure where exactly I am going wrong.
I am away from my work computer, I will upload a sample workbook with the codes in it first thing in the tomorrow! Again, my apologies for the confusion and lack of information in the original discussion, I was a bit frazzled and didn’t check before I submitted.
