Hello, trying to automate a big spreadsheet with 1500+ rows and not having much luck when trying VBA myself.
I have 3 columns.
Column A which contain cells with "Sum of" followed by a locale code such as en_US, the locale code changes.
Following each "Sum of" cell there is a number of project rows also in Column A, amount varies.
Column B with some values that is not important for this.
Column C I want to paste the locale code for each row of the project rows.
Loop it until there are no more rows with "Sum of" cells left.
Example:
<tbody>
</tbody>
Is there a good way of doing this beside using VBA? or do anyone have an example VBA I could use to accomplish this?
I have 3 columns.
Column A which contain cells with "Sum of" followed by a locale code such as en_US, the locale code changes.
Following each "Sum of" cell there is a number of project rows also in Column A, amount varies.
Column B with some values that is not important for this.
Column C I want to paste the locale code for each row of the project rows.
Loop it until there are no more rows with "Sum of" cells left.
Example:
Sum of en_US | ||
Task1 | 123 | need "en_US" here |
Task2 | 321 | need "en_US" here |
Sum of en_GB | ||
Task1 | 345 | need "en_GB" here |
<tbody>
</tbody>
Is there a good way of doing this beside using VBA? or do anyone have an example VBA I could use to accomplish this?