Hey folks, I've a basic macro that copies multiple columns of a source workbook to a destination workbook. What I have learned is that I need a way to only copy certain rows based on some sort of user-input variable. Depending on if the item listed is a "plush" or "figure" should determine the destination workbook(one for plushs and one for figures). I was thinking of a while loop that ran as many times as there are rows, each time with an if statement checking for some sort of variable(perhaps from another column with a p for plush or f for figure). But this means that it has to run through every row and every column which I'm sure isn't ideal. Is there an easier way of doing this?