notsurereall
09-23-2008, 05:40 PM
Hi.. ok i need a code that will take the value in A1, search through C2:W2 and match it. once it is matched i need to delete everything in that colmn from 3:100
example. A1= bob. search from C2:W2 for bob. match is found in H2, then delete H2:H100.
any idea??
example. A1= bob. search from C2:W2 for bob. match is found in H2, then delete H2:H100.
any idea??