Forum Discussion

CrystalH2A's avatar
CrystalH2A
Copper Contributor
May 01, 2023

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.

 

https://docs.google.com/spreadsheets/d/1tiwll1BkuN9gn2uwI1WwgKhf3R2ZQHXN/edit?usp=sharing&ouid=112636184308769450927&rtpof=true&sd=true

 

Thank you, in advance, for your help!

 

Crystal

Formulas and Functions

6 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    May 01, 2023
    It's possible with VSTACK and FILTER. If you're able to post an anonymized sample workbook, a formula could be drawn up.
    • CrystalH2A's avatar
      CrystalH2A
      Copper Contributor
      May 01, 2023

      Patrick2788 

       

      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

Resources