Find/Replace Macro to help consolidate location listing

[rhybeka]

Hi all!

I'm attempting to start automating a monthly report I will be building going forward. One of the tasks I need to do is to consolidate several of our location listings into one. Like say the list contains Akron,Canton,Dayton,and Columbus, I need to find these locations and change them all to Ohio Cities so they will all group in a pivot table. I have several of these I need to do since we have a few locations that need to be grouped. I've tried starting with Find/Replace code but it's giving me a subscript out of range error. I'm sure it's something simple I have or haven't done. Any help would be appreciated!

Becky

Please Login or Register  to view this content.

[Alf]

Without knowing the layouts of your data this may not be the fastest code but test and see if this works for you. Be sure to back up your data first.

Please Login or Register  to view this content.

Alf

[rhybeka]

Thanks for the help Alf! I'll give it a go and report back later!