Not sure this is possible. I have an excel sheet (Tab 1) and in column A, I created some check boxes for each row. Is it possible to check those boxes on some rows but not all and then the ones that are checked get copied to a new sheet (Tab 2) when I click a button? On the destination Tab 2, can the lines that are checked all appear in order? No blank rows in between? I know how to create the button and attach the code to the button. I just don't know the actual code to do it. If it's even possible. Tryng for a slick way to avoid copying and pasting.