I'm really green when it comes to excel, so please bear with me. I run a pivot table every day which values change every day. I want to take the data and paste it into another sheet so I can determine what I need for the day. Let's say that column a contains different products (a, b, c, d, etc.) but some days, some products are not there (like b and c), is there a way to search the column for all specific values (even if they are not present in the days pivot table) and paste the row into another sheet?