Detail: I have a workbook full of huge amounts of data and many rows in the workbook have a color background filling. I need all of those rows to be copied and pasted in a different sheet. The only twist is that it needs to be pasted as paste special to paste value and not formula. Pls help!!!! Thanks!