Hi there,
I'm doing our family accounting based on a regular download of bank account statement details in Excel. Based on certain keywords appearing in column H, I want a macro to fill out the category in column I. E.g. if cell H1 contains 'Wallmart' (apart from the usual incomprehensible stuff), I1 should be updated to 'Groceries'. The macro will have to loop through all cells to the end (the number of cells changes each period). Several 'keyword to category' combinations will need to be added.
I've read tons of posts, but so far none seems to do what I'm looking for. Any help to get me started would be much appreciated!
I'm doing our family accounting based on a regular download of bank account statement details in Excel. Based on certain keywords appearing in column H, I want a macro to fill out the category in column I. E.g. if cell H1 contains 'Wallmart' (apart from the usual incomprehensible stuff), I1 should be updated to 'Groceries'. The macro will have to loop through all cells to the end (the number of cells changes each period). Several 'keyword to category' combinations will need to be added.
I've read tons of posts, but so far none seems to do what I'm looking for. Any help to get me started would be much appreciated!