Hi all, I'm trying to self teach myself how to do this, and I cannot figure this out. Attached is an example of what I want to learn. If I have column A as my raw data, I want to have a macro that will search, for example, "apple" and move the data in the cell over to column B, search A for "banana", move to C, etc....
I feel that it's a simple task, but it's driving me nuts. In a real life application, I will likely have several hundred rows of data in "A", and would like to be able to search and sort it into the columns.
Thank you for anyone that can help me with this, greatly appreciated.
I feel that it's a simple task, but it's driving me nuts. In a real life application, I will likely have several hundred rows of data in "A", and would like to be able to search and sort it into the columns.
Thank you for anyone that can help me with this, greatly appreciated.