cut and paste in excel

LeeToo 

Lee -- you appear to be doing far too much "manually." That is what I suspected from the reference you made at the start to "cutting and pasting." So far as I can tell, from looking at the file you uploaded [thank you, by the way], you do indeed copy things over from your check register tab to your Bills tab (or vice versa).

This file you sent is for 2020, which has just begun, so there isn't much to work with there. I'm going to attach a purely "demo" file I created for somebody else here, to show how Pivot Table could be used to summarize data by payee (or, better, by category) and by month. And Pivot Table could do it "automatically" differentiating between checks/bill paid and those anticipated, etc.

If you'd be willing to upload your check register from 2019 I'd be happy to show you how Pivot Table could do that in your case. Short of that--and given privacy concerns, you might understandably prefer NOT to do so--this sample might show you enough to do it on your own.

Let me, though, take a few minutes to tell you the steps to go through.

1. Enter each check or payment transaction (credit card, auto pay, etc.), with date, payee, amount, budget category.
2. If you are entering anticipated but unpaid transactions as well, you should add a column that indicates "Paid/Unpaid"-- and use that in each case changing it from Unpaid to Paid as appropriate. That's an IF, you notice. Personally, I only track the ones actually paid. And I'll say more about that shortly.**
3. Make all these entries in the form of an Excel table, which means NO BLANK ROWS. I notice your register includes a section for the current month, but you can accomplish that by including the DATE as part of each row. If you want to see all of the January (or any other month) transactions, you can use the DATA....FILTER capability to filter your database.
4. Once you get a Pivot Table running, you can drill down from any month and category cell to see the underlying transactions.

So the point of all of this is: keep your register as a well-designed database, and use the capabilities of Excel (specifically the Pivot Table) to summarize, while retaining the ability to drill down for specifics (again through Pivot Table. In my very simple example file, if you click on "House" under "January" you'll see the two detail rows that went into that summary.

**My own expense tracking workbook contains a huge file of all bills paid (through the "Bill Pay" function at my bank), checks written, credit card transactions from several cards. Also all deposits. I populate that database by downloading from the bank(s) involved and (yes, manually, so far, although I'm planning in 2020 to improve my method so I can just import data in a consistent fashion even though the various banks don't report it that way).... I do semi-manually go through and apply budget categories and sub-categories to each transaction. And then, click on "Refresh" and the Pivot Table is updated by category by month showing how much we've spent. So the only data I enter is the budget categorization stuff...the rest is entered ONCE only, in the form of a download from each bank. No cutting and pasting from one page in my workbook to another. THAT is just not taking advantage of Excel's wonderful abilities.

I can tell you more, and as said, would be happy to show you with your own data but would not want to ask you to upload all actual data from last year. If you could render it less "true" but still very representative of reality. that might work well.