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.