I have an inventory worksheet with hundreds of items for various types of systems. I want to search a column "Retro" and if the value is greater than zero, indicating that item is a component of a "Retro" system, I want to copy the entire row to another sheet. It has been a while since I worked with macros and formulas, and I do not have VB experience. Is there a fairly simple way to do this?