Hi,
I currently have a searchable checklist that I would like to build in a function where if a row is selected by the values in column A, if there is already a True value for it in offset column E, it bounces back a message saying that it already is True (checked).
User is only allowed to check off this spreadsheet by successfully finding values in A:A (Part Nu8mber). Once A:A (Part Number) is an Activecell, it will switch E.E's value to true, thus checking it off.
Any help would be immensely appreciated!
I currently have a searchable checklist that I would like to build in a function where if a row is selected by the values in column A, if there is already a True value for it in offset column E, it bounces back a message saying that it already is True (checked).
User is only allowed to check off this spreadsheet by successfully finding values in A:A (Part Nu8mber). Once A:A (Part Number) is an Activecell, it will switch E.E's value to true, thus checking it off.
Any help would be immensely appreciated!
