guys i have a Excel file which already has a macro built into it which basically collects data from various sources and dumps it into to different sheet and then an auto refresh pivot will publish the data into pivot and then the snap snot of pivot goes into a mail, not i want to add another macro which will look for a value which is less then 80% in my pivot sheet column B and copy that row into another sheet in same excel.

some please help me with this.