I have a multi page workbook with items in different categories. I have created a sheet that pulls in any row that had a number in the ordered column. What I need now is a way to have another sheet create a pick list from the order sheet. I only need three of the cells in each row brought over but the cells in the pick list sheet are in different places than the order sheet. For example, on the order list I have columns A-G with headings for item#, description, price, etc. I only need to bring in the item#, description and number ordered to the pick list. Can someone please help me with the code for this? I've attached a small sheet that demonstrates what I have so far. Thanks in advance for any help!Test Order.xlsm