Combining mutiple IF and CountIF statements to help sort data

Hi,
I have a large spreadsheet with a quarters worth of financial transactions. One of the columns contains a description, which is overly complicated and mostly irrelevant. What I would like to have is an additional column that can search for keywords within the descriptions column and then output the relevant text to the new column. So I guess, grouping several description keywords into group. I can then filter on the new group names far easier.

For example one description reads “OS PAYPAL,processed on 29.07.13” all I am bothered with is the PAYPAL detail in this line and it needs to be translated in the new column to TAKINGS

I have managed to put together the following VB, which works great, however it outputs the keywords to different columns. I have tried putting the .Formula statements within the same With/End With group but only the last run .Formula sticks in the correct column.

My question is, can all of these Ifs/CountIFs be added into one .Formula, or is there a better way of doing it?

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here