I am creating a budget on excel partly as a way to increase my skills with excel and could use some help to figure out how to do something.

I want entries that I put in a tab labeled checking account to be automatically duplicated to another tab based on what expense category I specify in that entry. For example, tabs 1 and 2 will be accounts such as checking account and credit card account. Tabs 3 and 4 will be expense categories such as groceries and auto fuel. When I make an entry on the checking account tab and specify the category as groceries I would like that entry to be duplicated on the groceries tab. Likewise, if I specify the category as auto fuel I would like that entry to be duplicated on the auto fuel tab.



Does anyone know how to make that work?

Jim