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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sum of en_US[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task1[/TD]
[TD]123[/TD]
[TD]need "en_US" here[/TD]
[/TR]
[TR]
[TD]Task2[/TD]
[TD]321[/TD]
[TD]need "en_US" here[/TD]
[/TR]
[TR]
[TD]Sum of en_GB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task1[/TD]
[TD]345[/TD]
[TD]need "en_GB" here[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sum of en_US[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task1[/TD]
[TD]123[/TD]
[TD]need "en_US" here[/TD]
[/TR]
[TR]
[TD]Task2[/TD]
[TD]321[/TD]
[TD]need "en_US" here[/TD]
[/TR]
[TR]
[TD]Sum of en_GB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task1[/TD]
[TD]345[/TD]
[TD]need "en_GB" here[/TD]
[/TR]
</tbody>[/TABLE]
Is there a good way of doing this beside using VBA? or do anyone have an example VBA I could use to accomplish this?