Maarten321
New Member
- Joined
- Jul 7, 2016
- Messages
- 16
Hi guys,
I have been looking for a solution but haven't been able to find any vba or function that could do the trick.
VBA would work the best for me. The excel sheet has about 120k rows.
It has to calculate productinfo on the description or url. Some descriptions might not contain all info so that's why we also have it separated.
An example:
<tbody>
</tbody>
Percentage1 = calculation of B,C,D on Description
Percentage2 = calculation of B,C,D on URL
What would give the most accurate results? Calculation separated B,C,D or only on A.
Sheetname = "Clean"
Tablename = "Clean"
Would be nice if the vba is configured on the table data instead of ranges because they can change from time to time.
The header names in this example are also the real headers of the table.
Help me how i can put this in a vba.
Greetz Maarten
I have been looking for a solution but haven't been able to find any vba or function that could do the trick.
VBA would work the best for me. The excel sheet has about 120k rows.
It has to calculate productinfo on the description or url. Some descriptions might not contain all info so that's why we also have it separated.
An example:
A | B | C | D | E | F | G | H | ||||||
Query | Brand | Productname | ID | Description | Url | Percentage1 | Percentage2 | ||||||
<colgroup><col width="px"355""></colgroup><tbody> </tbody> |
<colgroup><col width="px"110""></colgroup><tbody> </tbody> |
<colgroup><col width="px"231""></colgroup><tbody> </tbody> |
<colgroup><col width="px"143""></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="87" style="width: 65pt;"></colgroup><tbody> </tbody> | ||||||||
<colgroup><col width="px"355""></colgroup><tbody> </tbody> |
<colgroup><col width="px"110""></colgroup><tbody> </tbody> |
<colgroup><col width="px"231""></colgroup><tbody> </tbody> |
<colgroup><col width="px"143""></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col width="87" style="width: 65pt;"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
Percentage1 = calculation of B,C,D on Description
Percentage2 = calculation of B,C,D on URL
What would give the most accurate results? Calculation separated B,C,D or only on A.
Sheetname = "Clean"
Tablename = "Clean"
Would be nice if the vba is configured on the table data instead of ranges because they can change from time to time.
The header names in this example are also the real headers of the table.
Help me how i can put this in a vba.
Greetz Maarten