Reply to thread

Message: <blockquote data-quote="AnotherCrappyDM" data-source="post: 6971639" data-attributes="member: 6807484">FA,One of the features I've seen requested a number of times in an autofill/autocomplete feature on the gear list.  While you can't autofill without a macro, there is a way to add an autocomplete function.  If you add a number of rows between the gear heading and the first gear slot, paste (or link) a list of all items in EquipmentList and then hide those rows, then items will show an auto complete while typing so long as no blank spaces are left.If you wanted to link the equipment list so that it updated dynamically, you can use the function =index(equipmentlist,A14) in the newly added cell B14.  Cell A14 would be 1. A15 would be A14+1 and drag down until the end of your list.  Again these rows would need to be hidden.</blockquote>