Forum Discussion
Generate list based on fillable cell values
I am trying to create a spreadsheet that allows us to generate a list of labels based on cells that have text and quantity information. Essentially, we have labels that we use on every project, and t...
Thank you for this reply, I definitely could have done a more thorough job explaining what I am trying to do here. As for the current spreadsheet, the version I have does not work in the way I want it to, but I have included a link to view it. My main objective here is to have a spreadsheet that I can utilize on multiple projects which allows me to fill a cell in with text as a template I.E Box.01 to Equipment.01 +. Then from that cell, I would like the ability to have it automatically generate a column of text based on a number referenced from another cell. For example, for Equipment01, we have 18 Boxes, so I would like to be able to have it generate Box.01 to Equipment.01 all the way through Box.18 to Equipment.01. I know how to do this easily enough through dragging autofill, but the problem is that there are 20 plus sets of equipment, each with a different quantity of boxes on them. Ideally, I would be able to enter a quantity of boxes that are associated with each piece of equipment, and have the spreadsheet generate the appropriate quantity and number range of labels for each piece of equipment from that information. This would be utilized by a number of different people, so I'm hoping to be able to keep it as simple as possible in regards to ease of use after it is set up, to the point that all the person has to do is enter the template information and box/equipment quantities, and the formula will take it from there, or possibly a script/macro button to be used. I really just need a good starting point on this, as I've never put together something quite like this and haven't been able to figure out how to even get it rolling.
First, I have to apologize for a long silence. I've both been traveling and involved in a lot of other things.
I have to say, though, that I still find what would appear to be relatively simple, entirely confusing. I'm not sure where to begin, what those "+" and "-" extensions are for, how they fit in to the task, and so forth.
It's also the case that I specialize (that may be too strong a word) in resolving Excel challenges by formula and function rather than VBA and macros, and it may be that what you need is the latter.
That said, let me point you to some text manipulation functions which, if you've not explored them all, might be at the base of what you need to resolve this.