I wanted to ask regarding VBA and updating a spread sheet column after a scan of values my table Column 1 Columns 2 Column 3 Column 4 123 123 123 NULL 456 456 996 NULL 1234 1234 1234 NULL And if i scan through the spread sheet range and wanted to set column 4 based on finding the values of cells in the range, through a loop in VBA identify row 2 val 1 = 446, value 2 = 456 and value 3 = 996. I want to find the values first before I update any columns, after i find the values i am looking for then update. I do not want to update row by row, like capture in a data set then review the data set and then update, want to check if the values exists first. Results set, if the values of 456, 456 and 996 are found in row 2 Column 1 Columns 2 Column 3 Column 4 123 123 123 Not Found 456 456 996 Found 1234 1234 1234 Not Found If no values are not found then Column 1 Columns 2 Column 3 Column 4 123 123 123 Not Found 456 456 996 Not Found 1234 1234 1234 Not Found Thank you
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)