Automated search and replace of a long list of items

[Hintysen]

Hello, our newspaper pulls high school sports schedules from various school websites and formats them to build daily event schedules to run in print. We download them as Excel documents. All the schools use the same software.
There are a lot of misspellings and mis-identifications in the listings, along with things that we just want to change to match our style guidelines. Fixing these one by one is a very tedious task.
I have built a table of mistakes (in Column A) and corrections for that mistake (in Column B) as found in a typical list. What I'd like to do is set up a macro that will work its way through this entire list and make all the searches and all the replacements. Also, I'd like to be able to add to the "master" list of errors/corrections as we find more.
Is there a way to do this? Thanks.

Here is the list of errors so far

Errors	Corrections
Wisconsin Rapids Lincoln	Wisconsin Rapids
UW Whitewater	UW-Whitewater
Stevens Point (SPASH)	Stevens Point
UW Platteville	UW-Platteville
University of Wisconsin - Whitewater	UW-Whitewater
University of Wisconsin - Platteville	UW-Platteville
University of Wisconsin-Whitewater	UW-Whitewater
University of Wisconsin-Platteville	UW-Platteville
Wisconsin - Whitewater	UW-Whitewater
Wisconsin - Platteville	UW-Platteville
Wisconsin-Whitewater	UW-Whitewater
Wisconsin-Platteville	UW-Platteville
Baraboo High School	Baraboo
Logan	La Crosse Logan
DC Everest	Schofield D.C. Everest
Northland Lutheran	Kronenwetter Northland Lutheran
Pacelli Catholic	Stevens Point Pacelli
Lakeland Union	Minocqua Lakeland
Lourdes Academy	Oshkosh Lourdes
Lourdes Academy	Oshkosh Lourdes
Lourdes	Oshkosh Lourdes
Kaukauna (Football Only)	Kaukauna
UWSP	UW-Stevens Point
/DLK
High School
Marquette	Milwaukee Marquette
Antioch Community	Antioch (Ill.)
Freeport	Freeport (Ill.)
Davenport	Davenport (Iowa)
Niles North	Skokie (Ill.) Niles North
Edgewood	Madison Edgewood
Madison Madison Edgewood	Madison Edgewood
Parker	Janesville Parker
Janesville Janesville Parker	Janesville Parker
Adams/Frie	Adams-Frie
University of Wisconsin (Shell)
University of Wisconsin Shell
Twining Park	Twining Park Monroe
Honey Creek Park	Honey Creek Park Monroe
Jack Young MS	Jack Young Middle School Baraboo
Arrowhead	Hartland Arrowhead
Hartland Hartland Arrowhead	Hartland Arrowhead
Westby Area	Westby
Heights MS/HS	Heights
Nicolet	Glendale Nicolet
Glendale Glendale Nicolet	Glendale Nicolet
Kettle Moraine	Wales Kettle Moraine
Wales Kettle Moraine Lutheran	Jackson Kettle Moraine Lutheran
Central	La Crosse Central
Aquinas	La Crosse Aquinas
HS
Badger	Lake Geneva Badger
Verona Area	Verona
Wilmot Union	Wilmot
Reedsburg Area	Reedsburg
Verona - Stampfl Field	Stampfl Field Verona
Beaver Dam - Prairie View Elementary School	Prairie View Elementary School Beaver Dam
Reedsburg - Nishan Memorial Park	Nishan Park Reedsburg
Luther Prep	Watertown Luther Prep
Watertown Watertown Luther Prep	Watertown Luther Prep
Southwestern/Benton/Cuba City	Southwestern co-op
Easton Valley Community	Easton Valley
Easton Valley	Preston (Iowa) Easton Valley
Notre Dame De La Baie Academy	Green Bay Notre Dame
Zumbrota-Mazeppa	Zumbrota-Mazeppa (Iowa)
School District of Somerset	Somerset
Hayward Community Schools	Hayward
Barron Area Schools	Barron
Stratford - WI	Stratford
Pec/Argyle	Pecatonica/Argyle
Regis	Eau Claire Regis
Eau Claire Eau Claire Regis	Eau Claire Regis
St. Mary’s Springs	Fond du Lac St. Mary’s Springs
Fond du Lac Fond du Lac St. Mary’s Springs	Fond du Lac St. Mary’s Springs
Escanaba	Escanaba (Mich.)
Menominee	Menominee (Mich.)
Gladstone	Gladstone (Mich.)
Byron Public Schools	Byron (Ill.)
Laona-Wabeno	Laona/Wabeno
Mishicot 2015-16	Mishicot
Northland Pines	Eagle River Northland Pines
Area Schools
School District of
School District
Community Schools
Zumbrota-Mazeppa	Zumbrota-Mazeppa (Minn.)
Goodman-Pembine Patriots	Goodman-Pembine
Oconto Falls Panthers	Oconto Falls
Saint Mary Springs	Fond du Lac St. Mary Springs
Saint	St.
(WI)
Becker	Becker (Minn.)
West Bend East Suns	West Bend East
LaCrosse	La Crosse
Ft. Atkinson	Fort Atkinson
Stevens Point Area	Stevens Point
Homestead	Mequon Homestead
Mequon Mequon Homestead	Mequon Homestead
Lake Forest	Lake Forest (Ill.)
Belvidere North	Belvidere (Ill.) North
Milwaukee School of Languages	Milwaukee Languages
Genoa Kinston	Genoa (Ill.) Kinston
DC	D.C.
Burlington Area School District	Burlington
Shawano Community	Shawano
Harold S. Vincent	Milwaukee Vincent
Salam	Milwaukee Salam
Milwaukee Milwaukee Salam	Milwaukee Salam
Dominican	Whitefish Bay Dominican
Whitefish Bay Whitefish Bay Dominican	Whitefish Bay Dominican
Jones Park	Jones Park Fort Atkinson
Baraboo - Pierce Park Field	Pierce Park Baraboo
Taylor Prairie Elementary School	Taylor Prairie Elementary School Cottage Grove
Reddan Soccer Park	Reddan Soccer Park Verona
Breese Stevens Field Madison	Breese Stevens Field
Coop	co-op
Tomahawk Hatchets	Tomahawk
De Forest	DeForest
Hartford Union	Hartford
The Prairie School	Racine Prairie
The Prairie	Racine Prairie
Verona High School	Verona
Kaneland	Maple Park (Ill.) Kaneland
Woyahn Complex	Woyahn Complex Waukesha
Complex Wisconsin Dells WI 1770 HWY 13 Wisconsin Dells 53965 WI United States	Complex Wisconsin Dells
Big Foot	Walworth Big Foot
Walworth Walworth Big Foot	Walworth Big Foot
Turner	Beloit Turner
Beloit Beloit Turner	Beloit Turner
La Crosse:	Lacrosse:
Mcfarland	McFarland
Cottage Grove - Fireman’s Park	Fireman’s Park Cottage Grove
Brandt Quirk Park-Watertown	Brandt Quirk Park Watertown
Goodman Pitch-East Madison College	Goodman Pitch Madison Area Technical College
Goodman Pitch-West Madison College	Goodman Pitch Madison Area Technical College
Goodman Pitch-North Madison College	Goodman Pitch Madison Area Technical College
Goodman Pitch-South Madison College	Goodman Pitch Madison Area Technical College
Whitman Middle School	Whitman Middle School Wauwatosa
Almond Bancroft	Almond-Bancroft
Westfield - WI	Westfield
Columbus Catholic Schools	Marshfield Columbus
St Croix	St. Croix
Hamilton	Sussex Hamilton
Catholic Central	Burlington Catholic Central
Burlington Burlington Catholic Central	Burlington Catholic Central
Stewartville	Stewartville (Minn.)
TBD	TBA
Woodstock	Woodstock (Ill.)
Rio Community School District	Rio
Warren Jr/Sr	Warren (Ill.)
Multiple Schools
Blackhawk Country Club - Madison	Blackhawk CC Madison
Country Club	CC
Golf Club	GC
Golf Course	GC
Springs Academy	Springs
Wisconsin Dells Location	Wisconsin Dells
Fischer Field - Jefferson WI	Fischer Field Jefferson
Fischer Field - Jefferson	Fischer Field Jefferson
The Oaks GC	The Oaks GC Cottage Grove
Wayland Academy	Beaver Dam Wayland
Park	Cottage Grove (Minn.) Park
White Bear Lake Area	White Bear Lake (Minn.)
Marquette University	Milwaukee Marquette
Milwaukee Milwaukee Marquette	Milwaukee Marquette
Plymouth School District	Plymouth
East Ridge	Woodbury (Minn.) East Ridge
Manitowoc Lincoln	Manitowoc
Kettle Moraine Lutheran	Jackson Kettle Moraine Lutheran
Jackson Jackson Kettle Moraine Lutheran	Jackson Kettle Moraine Lutheran
Eastside Lancers	Madison Eastside
Regina Dominican (Wilmette)	Wilmette (Ill.) Regina Dominican
Central Wisc. Christian	Waupun Central Wis. Christian
Central Wisconsin Christian	Waupun Central Wis. Christian
Home School Eagles	Southeast Wisconsin Christian Homeschool
Catholic Memorial	Waukesha Catholic Memorial
Waukesha Waukesha Catholic Memorial	Waukesha Catholic Memorial
Carroll University	Carroll University Waukesha
Orangeville	Orangeville (Ill.)
Pearl City	Pearl City (Ill.)
Allis Nathan Hale	Allis Hale
Schilberg Park	Schilberg Park Milton
Glen Erin GC	Glen Erin GC Janesville
Racine Saint	Racine St.
Catherines	Catherine’s
Sheboygan Area Lutheran	Sheboygan Lutheran
Geneva National GC	Geneva National GC Lake Geneva
Veterans Memorial Field (Portage)	Veterans Memorial Field Portage
Wanaki GC	Wanaki GC Lisbon
Burlington Notre Dame	Burlington (Iowa) Notre Dame
DeSoto	De Soto
University Lake	Hartland University Lake
Hartland Hartland University Lake	Hartland University Lake
- Hockey Rink
Middleton - Breitenbach Stadium	Breitenbach Stadium Middleton
Monterey Stadium Janesville	Monterey Stadium
Tomah La Grange Elementary	La Grange Elementary School Tomah
Prairie View Elementary School - Beaver Dam	Prairie View Elementar School Beaver Dam
Mary Rountree Evans Field	Mary Rountree Evans Field Baraboo
Badger High School	Lake Geneva Badger
Franklin Elementary
Parkview	Orfordville Parkview
Orfordville Orfordville Parkview	Orfordville Parkview
St. John’s Northwestern Military Academy	Delafield St. John’s NW
Saint Thomas More	Milwaukee St. Thomas More
Xavier	Appleton Xavier
Appleton Appleton Xavier	Appleton Xavier
Elkhart Lake Glen	Elkhart Lake-Glen
Winnebago Lutheran Academy	Fond du Lac Winnebago Lutheran
Lakeland Union	Minocqua Lakeland
Gale Ettrick Trempealeau	Gale-Ettrick-Trempealeau
Pius XI	Milwaukee Pius XI
Milwaukee Milwaukee Pius XI	Milwaukee Pius XI
Racine Case High School	Racine Case
Racine Horlick High School	Racine Horlick
Sauk Prairie - Sauk City Jaycee Baseball Park	Jaycee Baseball Park Sauk City
Fox Valley Lutheran	Appleton Fox Valley Lutheran
Assumption	Wis. Rapids Assumption
Wis. Rapids Wis. Rapids Assumption	Wis. Rapids Assumption
Wisconsin Rapids Wisconsin Rapids Assumption	Wis. Rapids Assumption
Wisconsin Rapids Assumption	Wis. Rapids Assumption
Coulee Christian	West Salem Coulee Christian
Krueger Haskell	Krueger-Haskell
LaFollette	La Follette
De Forest	DeForest
Bradley Technical	Bradley Tech
Racine Case High School	Racine Case
Racine Park High School	Racine Park
Living Word Lutheran	Jackson Living Word Lutheran
C-FC	Cochrane-Fountain City
Riverside University	Riverside
Mayo	Rochester (Minn.) Mayo
Divine Savior Holy Angels	Milwaukee Divine Savior Holy Angels
St. Mary Catholic	Neenah St. Mary
Abundant Life Christian	Madison Abundant Life

And here is part of the list as downloaded from one school website:

Activity	Type	Date	Time	Home/Host	Opponent	Location
Track: Boys Varsity	Invitational	03-19-20	5:00PM	Wisconsin Rapids Lincoln	Port Edwards, Reedsburg, Rhinelander	Wisconsin Rapids Lincoln High School
Track: Girls Varsity	Invitational	03-19-20	5:00PM	Wisconsin Rapids Lincoln	Port Edwards, Reedsburg, Rhinelander	Wisconsin Rapids Lincoln High School
Track: Boys Varsity	Invitational	03-20-20	TBD	Whitewater	Stoughton	UW Whitewater Kachel Fieldhouse
Track: Girls Varsity	Invitational	03-20-20	TBD	UW Whitewater	Stoughton	UW Whitewater Kachel Fieldhouse
Track: Boys Varsity	Invitational	03-20-20	4:00PM	Whitewater	Sauk Prairie	UW Whitewater/DLK Kachel Fieldhouse
Track: Girls Varsity	Invitational	03-20-20	4:00PM	Whitewater	Sauk Prairie	UW Whitewater/DLK Kachel Fieldhouse
Track: Girls Varsity	Invitational	03-20-20	4:00PM	Stevens Point (SPASH)	Baraboo High School, Logan, Wausau East, Marshfield, Appleton West, Oshkosh West, DC Everest, Mosinee, Madison Memorial, Seymour, Wisconsin Dells, Ashwaubenon, Auburndale, Gillett, Green Bay West, Hortonville, Marathon, Northland Lutheran, Omro, Pacelli Catholic, Rosholt, Waupaca, Wild Rose, Lakeland Union, Lakeland Union, Lakeland Union, Lakeland Union, Reedsburg, Bay Port, Nekoosa, Iola-Scandinavia, Lourdes, Appleton North, Kaukauna (Football Only), Kimberly, Neenah	UWSP Multi-Activity Center (MAC)
Track: Girls Varsity	Invitational	03-20-20	4:00PM	Stevens Point (SPASH)	Baraboo High School, Logan, Wausau East, Marshfield, Appleton West, Oshkosh West, DC Everest, Mosinee, Madison Memorial, Seymour, Wisconsin Dells, Ashwaubenon, Auburndale, Gillett, Green Bay West, Hortonville, Marathon, Northland Lutheran, Omro, Pacelli Catholic, Rosholt, Waupaca, Wild Rose, Lakeland Union, Lakeland Union, Lakeland Union, Reedsburg, Bay Port, Nekoosa, Iola-Scandinavia, Lourdes, Appleton North, Kaukauna (Football Only), Kimberly, Neenah	UWSP Multi-Activity Center (MAC)
Track: Varsity	Invitational	03-20-20	5:00PM	Lancaster	Viroqua, Lodi, Beloit Memorial, Oregon, Madison West, Platteville, Brodhead, Dodgeville, Madison East, McFarland, Middleton, Monroe, Mount Horeb, Prairie du Chien, Richland Center, River Valley, Waunakee, Antioch Community, Davenport West, Niles North, Freeport, Milton, Janesville Parker	UW-Platteville
Track: Boys Varsity	Invitational	03-20-20	5:00PM	UW Platteville	TBD	University of Wisconsin - Platteville
Track: Boys Varsity	Invitational	03-20-20	5:00PM	Lancaster	Viroqua, Lodi, Beloit Memorial, Oregon, Madison West, Platteville, Brodhead, Dodgeville, Madison East, McFarland, Middleton, Monroe, Mount Horeb, Prairie du Chien, Richland Center, River Valley, Waunakee, Antioch Community, Davenport West, Niles North, Freeport, Milton, Janesville Parker	UW-Platteville
Track: Boys Varsity	Invitational	03-20-20	5:00PM	Lancaster	Viroqua, Lodi, Beloit Memorial, Oregon, Madison West, Platteville, Brodhead, Dodgeville, Madison East, McFarland, Middleton, Monroe, Mount Horeb, Prairie du Chien, Richland Center, River Valley, Waunakee, Antioch Community, Davenport West, Niles North, Freeport, Milton, Janesville Parker	UW-Platteville
Track: Boys Varsity	Invitational	03-20-20	5:00PM	Lancaster	Antioch Community, Beloit Memorial, Brodhead, Davenport West, Dodgeville, Freeport, Janesville Parker, Lodi, Madison East, Madison West, McFarland, Middleton, Milton, Monroe, Mount Horeb, Niles North, Oregon, Platteville, Prairie du Chien, Richland Center, River Valley, Viroqua, Waunakee	UW-Platteville
Track: Girls Varsity	Invitational	03-20-20	5:00PM	UW Platteville	TBD	University of Wisconsin - Platteville
Lacrosse: Boys Varsity	Tournament	03-21-20	TBD	Marquette	DeForest	Milwaukee
Track: Boys Varsity	Invitational	03-21-20	TBD	Whitewater	Watertown	UW Whitewater/DLK Kachel Fieldhouse
Track: Boys Varsity	Invitational	03-21-20	TBD	Whitewater	Beaver Dam	UW-Whitewater
Track: Girls Varsity	Invitational	03-21-20	TBD	Whitewater	Watertown	UW Whitewater/DLK Kachel Fieldhouse
Track: Girls Varsity	Invitational	03-21-20	TBD	Whitewater	Beaver Dam	UW-Whitewater
Track: Boys Varsity	Invitational	03-21-20	10:00AM	Stevens Point (SPASH)	Baraboo High School, Logan, Marshfield, Appleton West, DC Everest, Mosinee, Madison Memorial, Seymour, Wisconsin Dells, Ashwaubenon, Auburndale, Green Bay East, Green Bay West, Hortonville, Marathon, Northland Lutheran, Pacelli Catholic, Rosholt, Waupaca, Wild Rose, Lakeland Union, Reedsburg, Nekoosa, Iola-Scandinavia, Lourdes, Appleton North, Fond Du Lac, Kimberly, Neenah	UWSP Multi-Activity Center (MAC)
Track: Boys Varsity	Invitational	03-21-20	10:00AM	Stevens Point (SPASH)	Baraboo High School, Logan, Marshfield, Appleton West, DC Everest, Mosinee, Madison Memorial, Seymour, Wisconsin Dells, Ashwaubenon, Auburndale, Green Bay East, Green Bay West, Hortonville, Marathon, Northland Lutheran, Pacelli Catholic, Rosholt, Waupaca, Wild Rose, Lakeland Union, Reedsburg, Nekoosa, Iola-Scandinavia, Lourdes, Appleton North, Fond Du Lac, Kimberly, Neenah	UWSP Multi-Activity Center (MAC)
Track: Boys Varsity	Invitational	03-26-20	4:00PM	Oshkosh North	DeForest	UW-Oshkosh Kolf Sports Center
Track: Girls Varsity	Invitational	03-26-20	4:00PM	Oshkosh North	DeForest	UW-Oshkosh Kolf Sports Center
Softball: Girls Varsity	Game	03-26-20	4:30PM	Madison West	Mount Horeb	Jefferson Middle School
Track: Girls Varsity	Meet	03-26-20	4:30PM	McFarland	Waunakee	McFarland High School
Softball: Girls Varsity	Game	03-26-20	5:00PM	Waunakee	Madison Memorial	Waunakee High School
Softball: Girls Varsity	Game	03-27-20	4:00PM	Parker	Fort Atkinson	Janesville Youth Sports Complex
Softball: Girls Varsity	Game	03-27-20	4:00PM	Janesville Craig	Milton	Janesville Youth Sports Complex
Track: Boys Varsity	City Meet	03-27-20	4:00PM	Edgewood	Madison East, Madison La Follette, Madison Memorial, Madison West	University of Wisconsin (Shell)
Softball: Girls Varsity	Game	03-27-20	5:00PM	Adams/Friendship	Reedsburg	Adams-Friendship High School
Softball: Girls Varsity	Game	03-27-20	6:00PM	Janesville Craig	Fort Atkinson	Janesville Youth Sports Complex
Softball: Girls Varsity	Game	03-27-20	6:00PM	Parker	Milton	Janesville Youth Sports Complex
Track: Boys Varsity	Invitational	03-28-20	9:00AM	Shullsburg/Benton	Westby Area, Parker, Oregon, Platteville, Black Hawk, Boscobel, Cassville, Darlington, Dodgeville, Fennimore, Monroe, Monticello, Lancaster, Belleville, Wisconsin Heights MS/HS	UW-Platteville
Track: Boys Varsity	Invitational	03-28-20	9:00AM	Shullsburg/Benton	Westby Area, Parker, Oregon, Platteville, Black Hawk, Boscobel, Cassville, Darlington, Dodgeville, Fennimore, Monroe, Monticello, Lancaster, Belleville, Wisconsin Heights MS/HS	UW-Platteville
Track: Boys Varsity	Indoor Relays	03-28-20	10:00AM	Watertown	Arrowhead, Beaver Dam, Mayville, Slinger, Waukesha South	Watertown High School
Track: Boys Varsity	Indoor Relays	03-28-20	10:00AM	Watertown	Arrowhead, Beaver Dam, Mayville, Slinger, Waukesha South	Watertown High School
Track: Boys Varsity	Invitational	03-28-20	10:00AM	Ripon	Jack Young MS	Ripon College
Track: Girls Varsity	Invitational	03-28-20	10:00AM	Ripon	Baraboo High School	Ripon College
Track: Girls Varsity	Indoor Relays	03-28-20	10:00AM	Watertown	Beaver Dam, Mayville, Slinger	Watertown High School
Track: Girls Varsity	Indoor Relays	03-28-20	10:00AM	Watertown	Beaver Dam, Mayville, Slinger	Watertown High School
Softball: Girls Varsity	Doubleheader	03-28-20	11:00AM	Monroe	Lodi	Twining Park
Soccer: Girls Varsity	Scrimmage	03-28-20	1:00PM	Monroe	Evansville	Honey Creek Park
Baseball: Varsity	Scrimmage	03-28-20	2:00PM	Sun Prairie	DeForest	Sun Prairie High School
Baseball: Varsity	Scrimmage	03-28-20	2:00PM	Waunakee	La Crosse Aquinas	Woodside Sports Complex
Track: Boys Varsity	Invitational	03-28-20	3:00PM	Mauston	Central, Logan, Black River Falls, Viroqua, West Salem, Holmen, Aquinas, Onalaska, Adams/Friendship, Neillsville, Nekoosa, Reedsburg	University of Wisconsin-La Crosse
Golf: Boys Varsity	1st day of practice	03-30-20	TBD	Monona Grove
Tennis: Boys Varsity	1st day of practice	03-30-20	TBD	Monona Grove
Tennis: Boys Varsity	1st day of practice	03-30-20	4:15PM	Sauk Prairie
Softball: Girls Varsity	Game	03-30-20	4:30PM	Badger	Fort Atkinson	Badger High School
Softball: Girls Varsity	Game	03-30-20	5:00PM	Monroe	Brodhead	Monroe Twining Park
Track: Boys Varsity	Invitational	03-31-20	TBD	Ripon	Stoughton	Ripon College
Track: Girls Varsity	Invitational	03-31-20	TBD	Ripon	Stoughton	Ripon College
Track: Boys Varsity	Invitational	03-31-20	4:00PM	Portage	Columbus, Wisconsin Dells	Portage High School
Track: Girls Varsity	Invitational	03-31-20	4:00PM	Portage	Columbus, Wisconsin Dells	Portage High School
Baseball: Varsity	Scrimmage	03-31-20	4:15PM	Verona Area	Edgewood	Verona - Stampfl Field
Baseball: Varsity	Game	03-31-20	4:30PM	Reedsburg	Wisconsin Dells HS	Reedsburg - Nishan Memorial Park
Baseball: Varsity	Game	03-31-20	4:30PM	Sun Prairie	Waunakee	Sun Prairie High School
Soccer: Girls Varsity	Scrimmage	03-31-20	4:30PM	Beaver Dam	Hustisford	Beaver Dam - Prairie View Elementary School
Baseball: Varsity	Game	03-31-20	4:45PM	Evansville	Monroe	Evansville High School
Baseball: Varsity	Game	03-31-20	5:00PM	Lodi	Baraboo High School	Dane Baseball Field
Baseball: Varsity	Game	03-31-20	5:00PM	Oregon	Beloit Memorial	Oregon High School
Soccer: Girls Varsity	Game	03-31-20	5:00PM	Tomah	Reedsburg	Tomah Veteran
Softball: Girls Varsity	Game	03-31-20	5:00PM	Stoughton	Fort Atkinson	Stoughton High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	DeForest	Portage	DeForest High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Milton	Monroe	Milton High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Reedsburg	Beaver Dam	Reedsburg Area High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Sauk Prairie	Baraboo High School	Sauk Prairie High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Waunakee	Oregon	Waunakee High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Waunakee	Oregon	Waunakee High School
Softball: Girls Varsity	Game	03-31-20	5:00PM	Monona Grove	Oregon	Taylor Prairie Elementary School
Track: Varsity	Invitational	03-31-20	5:00PM	Lancaster	Platteville, Argyle, Boscobel, Brodhead, Cuba City, Darlington, Fennimore, Monona Grove, Monroe, Mount Horeb, Prairie du Chien, River Ridge, Belleville, Shullsburg/Benton	UW-Platteville
Track: Boys Varsity	Invitational	03-31-20	5:00PM	Lancaster	Platteville, Argyle, Boscobel, Brodhead, Cuba City, Darlington, Fennimore, Monona Grove, Monroe, Mount Horeb, Prairie du Chien, River Ridge, Belleville, Shullsburg/Benton	UW-Platteville
Baseball: Varsity	Game	03-31-20	6:30PM	Portage	Poynette	Portage High School
Soccer: Girls Varsity	Match	03-31-20	6:45PM	Jefferson	Fort Atkinson	Jefferson High School
Soccer: Girls Varsity	Match	03-31-20	7:00PM	Monroe	Cambridge	Monroe High School
Soccer: Girls Varsity	Match	03-31-20	7:00PM	Sauk Prairie	Platteville	Sauk Prairie High School
Baseball: Varsity	Game	04-02-20	TBD	Beloit Memorial	Stoughton	Beloit Telfer Park
Soccer: Girls Varsity	Badger Challenge	04-02-20	TBD	Badger North	Edgewood, Fort Atkinson, Milton, Monona Grove, Monroe, Oregon, Stoughton, Watertown	TBA
Track: Girls Varsity	Invitational	04-02-20	TBD	Lancaster	Stoughton	UW Platteville
Tennis: Boys Varsity	Scrimmage	04-02-20	4:00PM	Watertown	Luther Prep	Brandt Quirk Park-Watertown
Baseball: Varsity	Game	04-02-20	4:30PM	Reedsburg	Adams/Friendship	Reedsburg - Nishan Memorial Park
Baseball: Varsity	Game	04-02-20	4:30PM	Milton	Verona Area	Schilberg Park
Baseball: Varsity	Game	04-02-20	5:00PM	Wisconsin Dells	Sauk Prairie	Woodside Sports Complex - Wisconsin Dells Location
Baseball: Varsity	Game	04-02-20	5:00PM	Marshall	Edgewood	Marshall High School
Baseball: Varsity	Game	04-02-20	5:00PM	Baraboo High School	Onalaska	Mary Rountree Evans Field
Baseball: Varsity	Game	04-02-20	5:00PM	DeForest	Columbus	DeForest High School
Soccer: Girls Varsity	Badger Challenge	04-02-20	5:00PM	Reedsburg	Fort Atkinson	Reedsburg Area High School
Soccer: Girls Varsity	Badger Challenge	04-02-20	5:00PM	Beaver Dam	Badger South	Prairie View Elementary School - Beaver Dam
Soccer: Girls Varsity	Badger Challenge	04-02-20	5:00PM	Mount Horeb	Watertown	Mount Horeb High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Reedsburg	Sauk Prairie	Reedsburg Area High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Portage	Waunakee	Portage High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	DeForest	Mount Horeb	DeForest High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Monroe	Watertown	Monroe High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Fort Atkinson	Oregon	Fort Atkinson High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Milton	Edgewood	Milton High School
Softball: Girls Varsity	Game	04-02-20	5:00PM	Baraboo High School	Beaver Dam	Baraboo - Pierce Park Field
Softball: Girls Varsity	Game	04-02-20	5:00PM	Monona Grove	Stoughton	Taylor Prairie Elementary School
Track: Boys Varsity	Invitational	04-02-20	5:00PM	Lancaster	Westby Area, Stoughton, Oregon, Belmont, Cassville, Evansville, River Ridge, Riverdale, Southwestern/Benton/Cuba City, Deerfield, Iowa-Grant, Potosi, Albany, Wisconsin Heights MS/HS, Easton Valley Community, Easton Valley	UW-Platteville
Track: Girls Varsity	Invitational	04-02-20	5:00PM	Lancaster	Westby Area, Stoughton, Oregon, Belmont, Cassville, Evansville, River Ridge, Riverdale, Southwestern/Benton/Cuba City, Deerfield, Iowa-Grant, Potosi, Albany, Wisconsin Heights MS/HS, Easton Valley Community, Easton Valley	UW-Platteville
Soccer: Girls Varsity	Badger Challenge	04-02-20	7:00PM	Waunakee	Badger South	Waunakee High School
Soccer: Girls Varsity	Badger Challenge	04-02-20	7:00PM	DeForest	Monona Grove	Goodman Pitch-East, Madison College
Soccer: Girls Varsity	Badger Challenge	04-02-20	7:00PM	Sauk Prairie	Edgewood	Sauk Prairie High School
Soccer: Girls Varsity	Badger Challenge	04-02-20	7:00PM	Portage	Milton	Poynette High School
Tennis: Boys Varsity	Invitational	04-03-20	11:00AM	University School of Milwaukee	Brookfield Academy, Kohler, Shorewood, Notre Dame De La Baie Academy, Edgewood	Pleasant Valley Tennis
Tennis: Boys Varsity	Invitational	04-03-20	1:00PM	Mukwonago	DeForest	Mukwonago High School
Baseball: Varsity	Tournament	04-03-20	2:00PM	Amherst	Amery, Eau Claire North, New Richmond, Eau Claire Memorial, Zumbrota-Mazeppa, Viroqua, School District of Somerset, Hayward Community Schools, Bloomer, Stoughton, Barron Area Schools, Spooner, Stratford - WI, Loyal, Boyceville, Cumberland, Gibraltar, Greenwood, Ladysmith, Mauston, Mishicot 2015-16, North Fond du Lac, Northland Pines, Pec/Argyle, Prairie du Chien, Regis, Laona-Wabeno, Gladstone, St. Mary's Springs, Menominee, Escanaba	Woodside Sports Complex
Softball: Girls Varsity	Tournament	04-03-20	2:00PM	Adams/Friendship	Bloomer, Cumberland, Menomonie, Waunakee	Woodside Sports Complex Wisconsin Dells, WI, 1770 HWY 13 , Wisconsin Dells 53965, WI United States
Softball: Girls Varsity	Tournament	04-03-20	2:00PM	Amherst	Byron Public Schools, New Richmond, Eau Claire Memorial, Zumbrota-Mazeppa, Milton, West Bend East Suns, Onalaska, Antigo, Hayward Community Schools, Bloomer, Loyal, Boyceville, Brillion, Cumberland, Elcho, Florence, Goodman-Pembine Patriots, Mishicot 2015-16, Northland Pines, Northwood, Oconto Falls Panthers, Phillips, St Croix Central, Laona-Wabeno, Waunakee, Becker, Saint Mary Springs, Menominee, Elmwood/Plum City (WI)	Woodside Sports Complex
Softball: Girls Varsity	Tournament	04-03-20	2:00PM	Amherst	Byron Public Schools, New Richmond, Eau Claire Memorial, Zumbrota-Mazeppa, Milton, West Bend East, Onalaska, Antigo, Hayward Community Schools, Bloomer, Loyal, Boyceville, Brillion, Cumberland, Elcho, Florence, Goodman-Pembine Patriots, Mishicot 2015-16, Northland Pines, Northwood, Oconto Falls Panthers, Phillips, St Croix Central, Laona-Wabeno, Waunakee, Becker, Saint Mary Springs, Menominee, Elmwood/Plum City (WI)	Woodside Sports Complex Wisconsin Dells, WI, 1770 HWY 13 , Wisconsin Dells 53965, WI United States
Softball: Girls Varsity	Doubleheader	04-03-20	3:30PM	DeForest	La Crosse Central	DeForest High School
Track: Girls Varsity	Invitational	04-03-20	4:00PM	Marshall	Cambridge, Columbus, Deerfield, Lake Mills, Lakeside Lutheran, Madison Country Day, Monona Grove, Pardeeville, Parkview, Rio Community School District, St. John's Northwestern Military Academy, Watertown Luther Prep, Westfield - WI	Marshall High School
Tennis: Boys Varsity	Game	04-03-20	4:15PM	Reedsburg	Viroqua	Reedsburg Area High School
Track: Boys Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Track: Boys Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Track: Boys Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Track: Girls Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Track: Girls Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Track: Girls Varsity	Quad	04-03-20	4:15PM	Mount Horeb	Dodgeville, Monroe, Stoughton	Mount Horeb High School
Baseball: Varsity	Game	04-03-20	4:30PM	Elkhorn	Fort Atkinson	Elkhorn Area High School
Baseball: Varsity	Game	04-03-20	5:00PM	Sauk Prairie	Lodi	Sauk Prairie - Sauk City Jaycee Baseball Park
Baseball: Varsity	Game	04-03-20	5:00PM	River Valley	Reedsburg	River Valley High School
Baseball: Varsity	Game	04-03-20	5:00PM	Edgewood	Cambridge	Edgewood High School
Baseball: Varsity	Game	04-03-20	5:00PM	Baraboo High School	Adams/Friendship	Mary Rountree Evans Field
Baseball: Varsity	Game	04-03-20	5:00PM	Watertown	Pulaski	Washington Park - Watertown
Baseball: Varsity	Game	04-03-20	5:00PM	Oshkosh North	Beaver Dam	Oshkosh North High School
Soccer: Girls Varsity	Scrimmage	04-03-20	5:00PM	Sun Prairie	Stoughton	Sun Prairie High School
Softball: Girls Varsity	Game	04-03-20	5:00PM	Lodi	Sauk Prairie	Lodi High School
Softball: Girls Varsity	Game	04-03-20	5:00PM	Reedsburg	River Valley	Reedsburg - Nishan Memorial Park
Softball: Girls Varsity	Game	04-03-20	5:00PM	Stoughton	Janesville Craig	Stoughton High School
Softball: Girls Varsity	Game	04-03-20	5:00PM	Fort Atkinson	Jefferson	Fort Atkinson High School
Softball: Girls Varsity	Tournament	04-04-20	TBD	Amherst	Milton	Woodside Sports Complex Wisconsin Dells, WI, 1770 HWY 13 , Wisconsin Dells 53965, WI United States
Track: Boys Varsity	Invitational	04-04-20	TBD	Whitewater	TBA	UW Whitewater Kachel Fieldhouse
Track: Boys Varsity	Invitational	04-04-20	TBD	Whitewater	Beaver Dam	UW-Whitewater
Track: Boys Varsity	Invitational	04-04-20	TBD	Whitewater	Watertown	UW Whitewater/DLK Kachel Fieldhouse
Track: Boys Varsity	Meet	04-04-20	TBD	Whitewater	Waunakee	UW Whitewater Kachel Fieldhouse
Track: Boys Varsity	Game	04-04-20	TBD	Madison West	Baraboo High School, Logan, Oak Creek, West Bend East, Racine Case High School, Elkhorn, Aquinas, Kettle Moraine, Fond du Lac, Neenah, Appleton East, DC Everest, Slinger, Milwaukee Hamilton, Stevens Point Area, Beloit Memorial, Madison Memorial, Wauwatosa East, Verona Area, Platteville, Grafton, Homestead, Madison East, Madison La Follette, Menomonee Falls, Middleton, Milwaukee School Of Languages, Monona Grove, Monroe, Port Washington, Waukesha North, Whitefish Bay, Columbus, Marquette, Genoa Kinston, Lake Forest, Belvidere North, Milwaukee Madison, Wilmot Union, South Milwaukee, Milwaukee Lutheran, Edgewood, Milwaukee Washington, Brookfield East, Milwaukee King	University of Wisconsin (Shell)
Track: Boys Varsity	Game	04-04-20	TBD	Madison West	Baraboo High School, Logan, Oak Creek, West Bend East, Racine Case High School, Elkhorn, Aquinas, Kettle Moraine, Fond du Lac, Neenah, Appleton East, DC Everest, Slinger, Milwaukee Hamilton, Stevens Point Area, Beloit Memorial, Madison Memorial, Wauwatosa East, Verona Area High School, Platteville, Grafton, Homestead, Madison East, Madison La Follette, Menomonee Falls, Middleton, Milwaukee School Of Languages, Monona Grove, Monroe, Port Washington, Waukesha North, Whitefish Bay, Columbus, Marquette, Genoa Kinston, Lake Forest, Belvidere North, Milwaukee Madison, Wilmot Union, South Milwaukee, Milwaukee Lutheran, Edgewood, Milwaukee Washington, Brookfield East, Milwaukee King	University of Wisconsin (Shell)
Track: Boys Varsity	Game	04-04-20	TBD	Madison West	Baraboo High School, Logan, Oak Creek, West Bend East, Racine Case High School, Elkhorn, Aquinas, Kettle Moraine, Fond du Lac, Neenah, Appleton East, DC Everest, Slinger, Milwaukee Hamilton, Stevens Point Area, Beloit Memorial, Madison Memorial, Wauwatosa East, Verona Area, Platteville, Grafton, Homestead, Madison East, Madison La Follette, Menomonee Falls, Middleton, Milwaukee School Of Languages, Monona Grove, Monroe, Port Washington, Waukesha North, Whitefish Bay, Columbus, Marquette, Genoa Kinston, Lake Forest, Belvidere North, Milwaukee Madison, Wilmot Union, South Milwaukee, Milwaukee Lutheran, Edgewood, Milwaukee Washington, Brookfield East, Milwaukee King	University of Wisconsin (Shell)
Track: Boys Varsity	Game	04-04-20	TBD	Madison West	Baraboo High School, Logan, Oak Creek, West Bend East, Racine Case High School, Elkhorn, Aquinas, Kettle Moraine, Fond du Lac, Neenah, Appleton East, DC Everest, Slinger, Milwaukee Hamilton, Stevens Point Area, Beloit Memorial, Madison Memorial, Wauwatosa East, Verona Area, Platteville, Grafton, Homestead, Madison East, Madison La Follette, Menomonee Falls, Middleton, Milwaukee School Of Languages, Monona Grove, Monroe, Port Washington, Waukesha North, Whitefish Bay, Columbus, Marquette, Genoa Kinston, Lake Forest, Belvidere North, Milwaukee Madison, Wilmot Union, South Milwaukee, Milwaukee Lutheran, Edgewood, Milwaukee Washington, Brookfield East, Milwaukee King	University of Wisconsin (Shell)
Track: Girls Varsity	Invitational	04-04-20	TBD	Whitewater	Beaver Dam	UW-Whitewater
Track: Girls Varsity	Invitational	04-04-20	TBD	Whitewater	Watertown	UW Whitewater/DLK Kachel Fieldhouse
Track: Girls Varsity	Meet	04-04-20	TBD	Whitewater	Waunakee	UW Whitewater Kachel Fieldhouse
Track: Girls Varsity	Invitational	04-04-20	TBD	Whitewater	Stoughton	UW Whitewater Kachel Fieldhouse
Tennis: Boys Varsity	Invitational	04-04-20	9:00AM	Mukwonago	DeForest	Mukwonago High School
Tennis: Boys Varsity	Invitational	04-04-20	9:00AM	Oshkosh North	Bay Port, Muskego, Oshkosh West, Stevens Point (SPASH), Watertown	Oshkosh North High School
Tennis: Boys Varsity	Invitational	04-04-20	9:00AM	Parker	Burlington Area School District, Union Grove, Fort Atkinson, Janesville Craig, Madison East, Monroe	Janesville Parker High School
Tennis: Boys Varsity	Invitational	04-04-20	9:00AM	Parker	Burlington Area School District, Union Grove, Fort Atkinson, Janesville Craig, Madison East, Monroe	Janesville Parker High School
Baseball: Varsity	Game	04-04-20	9:30AM	Fort Atkinson	Lake Mills	Jones Park

Thank you.

 

[Akuini]

If creating "System.Collections.ArrayList" is the problem (I don't know why) then try this one.
But it needs a temporary helper column, i.e col Z:

Sub a1123877b()
'https://www.mrexcel.com/board/threads/automated-search-and-replace-of-a-long-list-of-items.1123877/
Dim r As Range
Dim ary
Application.ScreenUpdating = False
Columns("Z").ClearContents

For Each r In Intersect(Selection, ActiveSheet.UsedRange)
    If InStr(r.Value, ", ") Then
        ary = Split(r.Value, ", ")
        With Range("Z1").Resize(UBound(ary) + 1)
            .Value = Application.Transpose(ary)
            .Sort Key1:=.Cells(1), Order1:=xlAscending, Header:=xlNo
            r.Value = Join(Application.Transpose(.Value), ", ")
            .ClearContents
        End With
    End If
Next
Application.ScreenUpdating = True
End Sub

 

[Hintysen]

Hi Akuini,
I still get the error report, same as before, thanks! Oops, I see you posted something else, I will try that next.

 

[Hintysen]

OK, so I tried your second example. And...

IT WORKS!

I have to set up these schedules for 52 high schools in 28 sports over three seasons, so three times a year I used to have to spend 50 to 80 hours poring over these lists manually. Now I bet I can do the whole schedule in 15 to 20 hours. Thank you both so much! What a great help. You have inspired me to find a VB class at the local community college and get after it myself, at age 60! It looks like I will have time for it now!

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.