Get instant live expert help on I need help with purchase order template excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Need help adding to a formula in Excel on Purchase Order - Copy and Paste tab.
Solved by F. S. in 16 mins
I have data within an excel spreadsheet where the plant/mat field repeats, however the purchase order date and net order price do not repeat. I need to figure out a formula to determine if the purchase order date is older and the net order price is greater based on the same plant/mat. For instance, material 273646 purchase order date of 7/10/2017 and net order price is greater than the 4/23/2018 and the 4/23//2018 order price Material Plant Plant/Mat Purchase Order Date Net Order Price Currency Price Unit Order Price Unit 273646 1024 1024273646 7/10/2017 116.94000 USDN 1 EA 273646 1024 1024273646 4/23/2018 115.85960 USDN 1 EA
Solved by O. A. in 26 mins
I'm trying to create a purchase order template. I use Excel for Mac. I need to have a searchable combo box (or any other suggestion), linked to a list with 1000 clients. I'd like to be able to click on a cell or the combo box and be able to write the first 2 or 3 letters of my client's name and find it, and not have to scroll down a thousand names. The list with names is on a different sheet and not on the first one, which is the interface of the purchase order. Once I select a name, I need other cells to auto populate with address, e-mail and telephone.
Solved by G. S. in 24 mins
I need a corrected formula for: =Purchase!A5/Purchase!C10*Purchase!A6
Solved by D. C. in 27 mins
I need to return a order number in one cell. By matching a part number to a part number list on another sheet. And also, looking at a date of issue raised, against the purchase order received date on the additional sheet.
Solved by C. F. in 13 mins