I am wanting to make a macro or something that will look into a specific column and find the rows that have a specific value in that column and then either delete the other rows or copy these rows into a new worksheet. Thanks