Okay this is rather complicated and I don't quite know how to describe what I am trying to achieve. What I want to do is update a number of cells with text and then stop updating once I fill up that number of cells.

So if I have 5 audio amplifiers that go in cells L13:O13 and I only have 4 "slots" open. Then fill slot I22 with the remaining one. There are 3 different amplifiers that are available to me. I have a helper row that spits out a number that then fills in the name for the "slot" I am filling.

Panel Layout.xlsx

I've attached the sheet I am trying to get this to work on. Any help would be greatly appreciated.