I have a macro that creates a pivot table and then copies the output over to a new worksheet. Problem is the row data that I copied over has additional unwanted entries. Can a macro or VBA look at the new column of data and see if it matches a list of data in another column. Then if it does, remove the the data in column 1 with it's adjacent cell and then shift everything up? I attached a sample of something that looks like what I have.example1.xlsx