Here is the scenario. I have an excel workbook. One of the sheets is named "Part Tree" which contains a list of parts all over meaning they go from left to right and go all the way to row 533.
I have another sheet called "Sheet1" that has just a list of parts in column "A" from row 1 to 153. I can’t figure out how to create a vba to find the parts listed in Sheet1 in the "Part Tree" tab. I want to find those parts in "Sheet1" in the "Part Tree" tab and have them deleted. So i want to vba code to find the first part which could be listed multiple time in the "Part Tree" tab and delete that part then find the next part and delete that part and all its references and so on and so forth for the entire list in Sheet1.
Any help would be very appreciative.
I have another sheet called "Sheet1" that has just a list of parts in column "A" from row 1 to 153. I can’t figure out how to create a vba to find the parts listed in Sheet1 in the "Part Tree" tab. I want to find those parts in "Sheet1" in the "Part Tree" tab and have them deleted. So i want to vba code to find the first part which could be listed multiple time in the "Part Tree" tab and delete that part then find the next part and delete that part and all its references and so on and so forth for the entire list in Sheet1.
Any help would be very appreciative.