Complex Solution Please!

[edam4i]

Hello,
I'm working on my finances and have downloaded my statements for the past 12 months.
I want to categorise my spending into various categories such as Car Expenses, Utilities, Loans and so on.

What I am looking to do in Excel is after I have my statements imported I want to be able to write code so that excel will automatically recognise and assign a category to each of my transactions.

I realise that I can't always have every transaction automatically categorised due to transactions changing but I am hoping to catch the most frequently used ones like bills, mortgage, cafe's I frequent etc.

For the ones outside this I can add manually or add to the code as I go along eventually building up a large database.

Is there code available that I can write to basically list all my chosen categories well over 20 at this stage and run the code so that it will in one go look at my transaction list and assign categories in the opposite cells.

My intention is to initially have Sub-Categories for all the transactions and then group the Sub-Categories into possible 6 main Financial Categories so I can graph.

All help and ideas greatly appreciated.

I have tried the If THEN ELSE Stmts in VBA but to be honest it didn't work out.

Example of my project is as follows.

Headers
Date Transaction Amount Sub-Category Category
21.01.19 Aldi 34.69 Aldi Groceries
19.01.19 Tesco 98.11 Tesco Groceries
14.01.19 Eir Mobile 25.00 Eir Mobile Communications
12.01.19 ABC Services 70.00 Diesel Car Expenses

I want to be able to see in detail my spending and true cost of living from my statements.

Thanks,
Colin

 

[edam4i]

Just to add when I am searching for a transaction they won't always be exact so I will need code to have a "Contains" option. For example I could have many transactions with Tesco in the name but with a code after the name ie. Tesco 45232453453 so I just want to be able to search for Tesco.
Thanks,

 

[mikerickson]

There isn't any existing Excel tool that will see Aldi and assign that the Groceries.

You will need to do that.

Manually enter transactions.
Write code to extract the Transaction and Category into a VLOOKUP table.
Later entries will use that table to find the Category from Transaction and/or expand the table as you add new transactions.