I've got the above product catalog (it goes on to ~124 rows) with 9 sheets for different finishes, with a 10th sheet to be an order form. What I would like to setup is a way when I enter a number in the Quantity to Order column that complete corresponding row (and cells?) are copied to the order sheet... sheet. This will only need to work on 1 sheet at a time so each product sheet would need what I assume is VBA code and a button to run. I would like entries to being on line 4 of the order sheet which is the sheet 10. The only other thing I have on this spreadsheet is a conditional formatting rule for when there is an entry in the quantity box to highlight that row so that we can more easily see and verify we have the right product selected. Any help would be great!