Search results

  1. G

    use list to create named ranges

    I have data that I am allowing user to drill down into one section at a time and using data validation "Indirect" statements referring to the previous cells. The supporting data is quiet large and I am looking for a way to automate the "named ranges" based on a column that i generate next to...
  2. G

    extract 3 numbers from a string

    I am trying to extract the first instance of 3 numbers from a string using an update query to update another field in the same table(Master Equipment) titled "Code". the field is called "Equipment". the strings vary in length as well as the location of the 3 numbers needed, but I have...
Back
Top Bottom