Text box to search values in a particular column in Excel Spreadsheet RRS feed

  • Question

  • Hi There

    I have a big spreadsheet with number of columns. I need to add a text box to search values in a column-A (ACO Number column). Once that particular ACONumber found, it should be able to do any changes to the rest of the cells. As it’s a big spreadsheet I need searched value row shows with header row. I appreciate if this is something you can help.

    For an example, as shown in attached screenshot below, I need a code to find value "ACO-009-008801" in column-A. Once "Search ACO#" button clicked, relevant details should come up with header details. Once they appear we should be able to do some changes and save it.

    Thanks heaps

    Thursday, April 25, 2019 10:57 PM