Reply to thread

Message: [QUOTE="Pete_UK, post: 3869339"] The advantage of using a UDF is that you can put in a cell: =UDF(whatever) but you can't put: =MACRO(whatever) If you used a macro it would be a one-off thing, eg click a button and it would evaluate all the strings in a range. That might be more suitable for you, as your inventory would not change frequently (from your examples, you seem to have one item per day !!) I still think it would be better to have a table of numeric values for each inventory item, and then form the concatenated string from that table. Hope this helps. Pete [/QUOTE]