Auto-Row Fill based on Quantity of components

Hello all,

I'm working on a simple MRP model and I'm having a tough time with creating a macros/script for a feature that I'm trying to add. I'm attached a file that I think will explain it sufficiently (see tab "Inventory Allocation") to get to the heart of the problem. I'll try to give a brief summary here, but I think it would be easier to look at the spreadsheet.

I'm trying to create an auto-fill feature for the Inventory Allocation tab based on the items being worked on in the Work in Process tab. Depending on what product is being produced in the WIP tab, will depend on the number of rows the Inventory Allocation tab will occupy, because all products require a different number of components to be made.

I would really appreciate any help with this one. It's by far the most troubling piece for me.

You could use COUNTIFS to determine how many rows you need and use .Resize with that number when you output the Formulae.

See attached and comment

Please Login or Register  to view this content.