Search and Highlight Excel
28 August 2016Situation: Change of Command Inventory.
Problem: It's all hands on deck getting equipment on the Commander's hand receipt lined up, in the hall way or out in the motor pool, in LIN order followed by NSN order along with all of it's BII. This is done in large part to minimize the time it takes for the Commander conducting the inventory to flip through the many printed out pages of his property book and find the item being inventoried. To save a few hours of his time, we spend a few days doing this work to prepare.
Solution: Wouldn't it be nice if we could just have that hand receipt on digits, scan a bar code, automagically search the document and highlight it? Well now you can! Introducing the Search And Highlight Excel (SAHE) xlsm document!