i have 4 tabs in a workbook that i would like to loop through, find the header "ClaimName", which resides in different location IF it exists at all, and then replace the values "Claim1Score", "Claim12Score", "Claim3Score", "Claim4Score" with "Claim 1", "Claim 2" ... etc.
I am rusty with vba. I have found similar questions around, but cannot seem to quite get them to work out.
Hope you can help! Thanks!
I am rusty with vba. I have found similar questions around, but cannot seem to quite get them to work out.
Hope you can help! Thanks!