nix14085
01-16-2014, 02:06 PM
Aloha!
I am new to VBA and trying to learn some code by setting up a personal budget. I have been copying data as exported from my bank and slowly setting up an excel document that filters the data based on various criteria. the problem i am running into is the file from my bank include a lot of extra information that i don't need i have included a sample line below
POS PURCHASE ABC STORES 123456789012345 ABC STORES Honolulu HI R111222333444555US
What I would like to do is search within the column (column C) for specific criteria (eg. ABC STORES) and then clear the cell and replace it with a given string (eg. PURCHASE - ABC STORES). I am trying to figure out a way to do this with VBA for certain purchases I make often to save time when importing data. I have been trying to search for a similar case but I haven't found anything that seems to work. Can anyone point me in the direction of where to start for something like this, or what functions i should be using? I am in excel 2010
Thanks!
I am new to VBA and trying to learn some code by setting up a personal budget. I have been copying data as exported from my bank and slowly setting up an excel document that filters the data based on various criteria. the problem i am running into is the file from my bank include a lot of extra information that i don't need i have included a sample line below
POS PURCHASE ABC STORES 123456789012345 ABC STORES Honolulu HI R111222333444555US
What I would like to do is search within the column (column C) for specific criteria (eg. ABC STORES) and then clear the cell and replace it with a given string (eg. PURCHASE - ABC STORES). I am trying to figure out a way to do this with VBA for certain purchases I make often to save time when importing data. I have been trying to search for a similar case but I haven't found anything that seems to work. Can anyone point me in the direction of where to start for something like this, or what functions i should be using? I am in excel 2010
Thanks!