Hi guys, looking for advise as to how to approach this....
There is a sheet in my workbook called "Tanks". It has a couple of dozen rows that contain data about all the tanks on a vessel.
A second sheet, called "Inspection", has perhaps half a dozen rows that contain data about the tanks that are selected for inspection. Column A in each worksheet is called "Tank Name". The next five columns in "Inspection" contain data from five of the columns in "Tanks".
At the moment, the user enters the tank name of tanks to be inspected into column A of "Inspection", and a VLOOKUP function pulls over the data from "Tanks". However, if the user types the name in "Inspection" even slightly different from how he typed it in "Tanks" - he types 4 STBD in one, and then 4 Stbd or 4STBD, for example in the other - it errors.
What I'd like is to have a field in "Tanks" for "Is Used?". If the user puts an 'X' in it, then "Tank Name" from that row is copied over into Column A of Inspection.
How would I approach this?
Bookmarks