I've looked around on the forum for guidance on this, but am a bit inexperienced so may have missed something obvious - sorry!
I'm hoping to be able to convert a set of types and no. of instances into a list of those instances in a way that is dynamic so that I can update the number of instances for example and the list would update (filling out new rows).
Type 1 0 Type 2 3 Type 3 2 Type 4 1
would return
Project 1 Type 2 Project 2 Type 2 Project 3 Type 2 Project 4 Type 3 Project 5 Type 3 Project 6 Type 4
If it's possible without VBA that would be brilliant.
Ideally it wouldn't be returned as an array - although it's not a problem if it does (especially if that's simpler)
I'm thinking there would be some function defined in VBA that returns an array an can sit over 100 rows and populate as the number of instances changed?
It needs to be able to manage when the no. of instances changes e.g. Type 4 has 10 instances and Type 2 has no instances
Hope that's clear, thanks very much for the help!
Bookmarks