Yeah I messed myself up a little on that. It would need to be able to search for a few keywords such as "no access" and also blank or no value cells. Based on some inspections I'm looking at it looks like it should look for information in A or B or C it does not need to be all three. Several inspections do not have have addresses. Actually it could simply look at column "c" as this is the description of the device and is required for all inspections. So it could simply look for a value "text value" in column "C"
If value or text is found in column "C" and no value is found in column "E" "Results" then it should do the same thing as the failed devices. It should be copied to the "Missed Devices" page and then if a value is entered on that page. it should be updated.
If NO value is found in column "C" and no value is found in column "E" "Results" it should do nothing at all. This should keep the macro from pulling rows are not used or left empty for the rest of the worksheet. This can be run from a macro and I will simply link it to a virtual button.
That way when the user has finished the testing they can run a search for all missed devices, or no access devices, and try and find them later if needed.
Thanks
Reply With Quote
Bookmarks