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 ...
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?
- I'm using Microsoft 365, Excel version 2303.
