Good morning - Thanks for working on this! The two tables that you had me change were once the same as you said, but I had tried several things to get up and running and forgot to change them back to what I had originally named them, like the other tables on that worksheet.

I have a little issue tho as it seems to work fine when "NO" is put in, but it gives an error code when I remove the "NO". Once an item has reconciled, the user will then go in and change that dropdown from "NO" to "YES" and the data would then be removed from the Table on the "MONTHLY GOE RECONCILIATION" worksheet.

The error shows in your code on the highlighted line .ListObjects(destTable).HeaderRowRange.Select

Not sure how to set that code up to remove the copied data when "YES" or blank cell selected.

Also, when that data line, such as when I select "NO" on one line of the 21000 State Program Travel worksheet and the data is copied to the "MAIN GOE RECONCILIATION" worksheet on the table "_21000_State_Program_Travel, the totals row down below on column D does not reflect the value that was copied to column D row 4 even though there is a formula in D102. Why wont that pick up the copied data?

Thanks again for your help.