Categorizing Budget Items

I am trying to categorize budget items. When I enter an expense, the type of expense, the date and other details in a row and in separate columns, I am trying to have a column that if I put an "x" in it, then the other cells in that row that have to do with that expense are copied and placed in a separate spreadsheet. I am doing this to have one spreadsheet that has all of my expenses, and a second spreadsheet that only has expenses of a certain type. In the past I have manually copied and pasted each time that I enter an expense of this special type, but I do not want to do that anymore if there is a way to do it more simply.

That is a great start! I can tell this is moving in the right direction. Attached is a sample file. I am trying to get the items marked with an x in column D to be copied to the Special Expense Item Sheet.

I am interested to see how the formula you proposed would work into this?

Thank you for your help!Expense Items Budget.xls

Canapone,

Your formula seems to work perfectly in the example file you did. However, I am unable to replicate this process in the actual file I am using. Sorry, the formula is a little over my head I am afraid. I have attached the actual file I am working with and trying to get to work. Is there any way you could show me how the formula would work here?

In the 'Checkbook' Tab, I enter my expenses. Then, in column 'F' I write 'Credit Card' If I used my Credit Card (I do this instead of putting 'X')

When I write "Credit Card' in an expense line, I want it to be copied over to my 'Credit Card' Sheet.

Does this make Sense? Sorry to be a bother- I so appreciate your help!

WBT 2015 Rough 2.xls