I have a spreadsheet with more than 600 columns. Unfortunately several of the headers are identical.
I would like to rename these headers so that they become unique.
Lets say that part of the headers looks like this:
<tbody>
</tbody>
I would have liked to rename this so that they read:
<tbody>
</tbody>
How can I do this with a macro?
I would like to rename these headers so that they become unique.
Lets say that part of the headers looks like this:
a | b | c | d | d | d | d | e | f | f | f | f |
<tbody>
</tbody>
I would have liked to rename this so that they read:
a | b | c | d-1 | d-2 | d-3 | d-4 | e | f-1 | f-2 | f-3 | f-4 |
<tbody>
</tbody>
How can I do this with a macro?