I tried the methods found on the internet. However, they did it either with “power query” or vba. “Power query” doesn’t work for me. Those made with VBA do not fit this website. How should I proceed?
<div class="table-wrap">
<div class="table horizontal">
<table class="excelexport" data-csvname="malitablo">
<thead>
<tr>
<th style="width:50%"></th>
<th class="form-group"><select name="ctl00$ctl58$g_00f9bafa_387b_423c_b297_f8592de90819$ctl00$ddlMaliTabloDonem1" id="ddlMaliTabloDonem1" class="select">
<option selected="selected" value="2024/3">2024/3</option>
<option value="2023/12">2023/12</option>
<option value="2023/9">2023/9</option>
<option value="2023/6">2023/6</option>
</select></th>
<th class="form-group"><select name="ctl00$ctl58$g_00f9bafa_387b_423c_b297_f8592de90819$ctl00$ddlMaliTabloDonem2" id="ddlMaliTabloDonem2" class="select">
<option value="2024/3">2024/3</option>
<option selected="selected" value="2023/12">2023/12</option>
<option value="2023/9">2023/9</option>
<option value="2023/6">2023/6</option>
</select></th>
<th class="form-group"><select name="ctl00$ctl58$g_00f9bafa_387b_423c_b297_f8592de90819$ctl00$ddlMaliTabloDonem3" id="ddlMaliTabloDonem3" class="select">
<option value="2024/3">2024/3</option>
<option value="2023/12">2023/12</option>
<option selected="selected" value="2023/9">2023/9</option>
<option value="2023/6">2023/6</option>
</select></th>
<th class="form-group"><select name="ctl00$ctl58$g_00f9bafa_387b_423c_b297_f8592de90819$ctl00$ddlMaliTabloDonem4" id="ddlMaliTabloDonem4" class="select">
<option value="2024/3">2024/3</option>
<option value="2023/12">2023/12</option>
<option value="2023/9">2023/9</option>
<option selected="selected" value="2023/6">2023/6</option>
</select></th>
</tr>
</thead>
<tbody id="tbodyMTablo">
<tr class='arabaslik'><td colspan='5' class='sectorAverage'>Bilanço</td></tr>
<tr><td>Dönen Varlıklar</td><td>6.577.347.205</td><td>5.018.751.984</td><td>4.429.257.937</td><td>3.405.919.362</td></tr>
<tr><td> Nakit ve Nakit Benzerleri</td><td>1.359.452.617</td><td>842.498.658</td><td>917.056.568</td><td>930.685.667</td></tr>
<tr><td> Finansal Yatırımlar</td><td>1.015.696.737</td><td>877.140.664</td><td>512.630.624</td><td>164.866.073</td></tr>
<tr><td> Ticari Alacaklar</td><td>3.495.096.345</td><td>3.255.781.773</td><td>2.902.505.806</td><td>2.121.057.882</td></tr>
<tr><td> Finans Sektörü Faaliyetlerinden Alacaklar</td><td>0</td><td>0</td><td>0</td><td>0</td></tr>
<tr><td> Diğer Alacaklar</td><td>682.216.979</td><td>32.304.565</td><td>82.811.223</td><td>182.235.499</td></tr>
<tr><td> Müşteri Sözleşmelerinden Doğan Varlıklar</td><td>0</td><td>0</td><td>0</td><td>0</td></tr>
<tr><td> Stoklar</td><td>0</td><td>0</td><td>0</td><td>0</td></tr>
<tr><td> Canlı Varlıklar</td><td>0</td><td>0</td><td>0</td><td>0</td></tr>
<tr><td> Diğer Dönen Varlıklar</td><td>24.884.527</td><td>11.026.324</td><td>14.253.716</td><td>7.074.241</td></tr>
</tbody>
</table>
<br />
<p class="bordered-link blue">
<small>
<span id="ctl00_ctl58_g_00f9bafa_387b_423c_b297_f8592de90819_ctl00_lblMaliTabloDesc">Mali tablolar döviz kuruna çevrilirken; bilanço bilgileri için dönem sonu, gelir tablosu bilgileri için ilgili dönem/yıl ortalama kur bilgileri kullanılmaktadır.</span>
</small>
</p>
</div>
</div>
“class” names repeat in multiple places
New contributor
Cihan OFLAZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.