Forum Discussion
Formula for Master Order form from multiple sheets while considering stock level in inventory sheet
Good afternoon!
I am creating an order form in a single workbook that has a 'Master Order form' sheet, 'Master Inventory' sheet and multiple 'Location Order forms' sheets. I'm trying to create a system that automatically populates the 'Master Order form' from manually entered data entered per 'Location Order form', but only if the 'Master Inventory' is at or below a stock threshold.
What formula would I use on the 'Master Inventory' sheet to either pull from stock or kick the number to the 'Master Order Form'? See Google Doc below made with the Excel spreadsheet.
Thank you, in advance, for your help!
Crystal
- It's possible with VSTACK and FILTER. If you're able to post an anonymized sample workbook, a formula could be drawn up.
Hi, Patrick!
Thank you for your reply. Below is a link to the Google Doc I created using the Excel book. Unfortunately, it does not appear that I am able to upload the original file in my original message or a reply. https://docs.google.com/spreadsheets/d/1tiwll1BkuN9gn2uwI1WwgKhf3R2ZQHXN/edit?usp=sharing&ouid=112636184308769450927&rtpof=true&sd=true
I would be grateful for any assistance!
Thanks, again!
Crystal
- Thank you. Which version of Excel are you using?
