Forum Discussion
I need some help digitising our paper order system, but struggling with the code!
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.