Hi there.
I really need urgent help. I have about 270 old records and need to order them by their County. I need to create a function/macro that will search for a word value (e.g. West Midlands) and have it move that word one cell to the right. Not sure if I'm posting this in the correct area but I really need the help here. Ideally I want it to do this:
1: Search for a specific word based from a list of nine words.
2: When it has found one of the words: Move that word one cell to the right of where it was found.

Thanks.