I'm new to this!

I want to create a simple workbook. The first worksheet would be a running bank balance with each check and deposit itemized. One of the columns would have in it the category (clothes, food, gas, interest, etc.) for each entry. Each category then would have it's own separate worksheet. After entering the data in the first worksheet I want it to also be automatically be entered in the next available row in the worksheet of the corresponding category. I don't want to copy and past or filter if possible. This is probably easy for those of you on this list. Thanks, Jerry

You have to use macro for this