I need a macro that searches for values in "Index" that match values in "Restricted List" (the two tables are on separate spreadsheets). Once a match is found, I need it to change the value of the "Weight" column cell in "Index" to a value of 0. I need this to be done with a macro because the values being searched are copied and pasted into the cells. So a vlookup will not do the trick.forum.ozgrid.com/index.php?attachment/54661/
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!