Forum Discussion

TripL1337's avatar
TripL1337
Copper Contributor
Jun 12, 2022

Updating equipment locations

Hello! I'm trying to create a equipment tracker that lists field numbers for equipment under columns labeled as specific locations.   Each column has a name such as D1, D2 etc.. On a separate she...
excel
Formulas and Functions
TripL1337's avatar
TripL1337
Copper Contributor
Jun 12, 2022

Here are examples of the above post. 

                                                                               FIELD #               FROM                     TO

6-JunTRIPLETTGT12D1D14
6-JunTRIPLETTHY01C3D8
6-JunTRIPLETTB405D2D11
6-JunTRIPLETTC118D7C3
6-JunTRIPLETTGT05C11C7
6-JunTRIPLETTHT27C14D15
6-JunTRIPLETTHS06D15D2
6-JunTRIPLETTNC90D17C3
6-JunTRIPLETTB190D8C7
6-JunTRIPLETTFL07C9SHOP
6-JunTRIPLETTFL14C7SHOP

 

      D1            D2           D7            D8            D9            D11  ( Small example of columns )