Can someone suggest a good way to store values as follows:
So, I have a macro that will run and gather let’s say 6 different values with titles: Name, Type, Length, Cost, Project. This will happen multiple times over 2 weeks and possibly total up to 50 unique values for each of those. So that I could have say 50 items that each have a Name, Type, Length, Cost, Project etc.
I was thinking about doing something like
And ideally each time the main macro ran it would store these values in the ‘next’ available “Item”, so if something is already stored in “Item4Name… etc.” then it would use “Item5Name” etc. I could create all these “Item” variables up to 50, but then I’d need to specifically reference “Item5Name…Item6Name … etc.” with lots of If / Then loops. Is there a way to have the Variables created dynamically and have them looked at automatically to determine if they’re full and if so have the macro create the next one etc.
After a few weeks I would set all these “Item” variables back to ‘empty’ and start again.
Does that make sense?
Any help is appreciated!