I have a workbook that creates four worksheets with data that will be uploaded into an ACCESS database. The worksheet names are ("chrts", "Top10", "gics", "Ctry"). However, due to user changes, some of the row headers needs to be changed. That is, say a row is labled "Market Cap" in the source data, but needs to be changed to "Market Capilization" on the upload worksheet. I have a two-column range ("RowHeaderChanges") that has the OldRowHeader column and a NewRowHeader column which holds this old/new information. So, how do I loop through this range and change the values? I need locate in column A on each worksheet the value "Market Cap" and change it to "Market Caplization", and then go to the next old value in the range, loop through the worksheets checking for this value and update to the new value if it is found. All this must be done in VBA.
Public Sub UpdateRowHeaders()
Dim varGroup As Variant
For Each varGroup In Array("chrts", "Top10", "gics", "Ctry")