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.
- Are you open to re-structuring the arrangement of the workbook? There are a few things with the workbook which make rolling up the data and analyzing more difficult. Mostly it's the Category names appearing in merged cell across the sheets. It would make things easier if the category# appeared vertically in a column. Additionally, the breaks in the order sheets between Category 1-4.
I've been throwing a few Lambdas at the existing workbook but there's a lot of legwork that needs to be done to fix the data so I can analyze it.