• 05-04-2022, 16:56:11
    #1
    Merhaba,

    <div style="display: none;" id="af">

    Bu şekilde alt alta 200 satır yazmam gerekiyor. ID kısmı ise her satırda değişecek ve elimde 2 harfli ülke kodları mevcut. Bunu otomatik bir şekilde yaptırabilirmiyiz? NotePad++ değilde Excel ile olur sanırım. Tam olarak nasıl yapabilirim?
  • Kabul Edilen Cevap
    • A Hücresi: <div style="display: none;" id="
      B Hücresi: Ülke Kodu
      C Hücresi: ">

      B hücresine ilgili verilerinizi yapıştırın.
      A ve C hücresini aşağı doğru çoğaltın.
      Bu kadar.
  • 05-04-2022, 17:02:20
    #2
    <div style="display: none;" id="ad">
    <div style="display: none;" id="ae">
    <div style="display: none;" id="af">
    <div style="display: none;" id="ag">
    <div style="display: none;" id="ai">
    <div style="display: none;" id="al">
    <div style="display: none;" id="am">
    <div style="display: none;" id="ao">
    <div style="display: none;" id="aq">
    <div style="display: none;" id="ar">
    <div style="display: none;" id="as">
    <div style="display: none;" id="at">
    <div style="display: none;" id="au">
    <div style="display: none;" id="aw">
    <div style="display: none;" id="ax">
    <div style="display: none;" id="az">
    <div style="display: none;" id="ba">
    <div style="display: none;" id="bb">
    <div style="display: none;" id="bd">
    <div style="display: none;" id="be">
    <div style="display: none;" id="bf">
    <div style="display: none;" id="bg">
    <div style="display: none;" id="bh">
    <div style="display: none;" id="bi">
    <div style="display: none;" id="bj">
    <div style="display: none;" id="bl">
    <div style="display: none;" id="bm">
    <div style="display: none;" id="bn">
    <div style="display: none;" id="bo">
    <div style="display: none;" id="br">
    <div style="display: none;" id="bs">
    <div style="display: none;" id="bt">
    <div style="display: none;" id="bv">
    <div style="display: none;" id="bw">
    <div style="display: none;" id="by">
    <div style="display: none;" id="bz">
    <div style="display: none;" id="ca">
    <div style="display: none;" id="cc">
    <div style="display: none;" id="cd">
    <div style="display: none;" id="cf">
    <div style="display: none;" id="cg">
    <div style="display: none;" id="ch">
    <div style="display: none;" id="ci">
    <div style="display: none;" id="ck">
    <div style="display: none;" id="cl">
    <div style="display: none;" id="cm">
    <div style="display: none;" id="cn">
    <div style="display: none;" id="co">
    <div style="display: none;" id="cr">
    <div style="display: none;" id="cu">
    <div style="display: none;" id="cv">
    <div style="display: none;" id="cx">
    <div style="display: none;" id="cy">
    <div style="display: none;" id="cz">
    <div style="display: none;" id="de">
    <div style="display: none;" id="dj">
    <div style="display: none;" id="dk">
    <div style="display: none;" id="dm">
    <div style="display: none;" id="do">
    <div style="display: none;" id="dz">
    <div style="display: none;" id="ec">
    <div style="display: none;" id="ee">
    <div style="display: none;" id="eg">
    <div style="display: none;" id="eh">
    <div style="display: none;" id="er">
    <div style="display: none;" id="es">
    <div style="display: none;" id="et">
    <div style="display: none;" id="fi">
    <div style="display: none;" id="fj">
    <div style="display: none;" id="fk">
    <div style="display: none;" id="fm">
    <div style="display: none;" id="fo">
    <div style="display: none;" id="fr">
    <div style="display: none;" id="ga">
    <div style="display: none;" id="gb">
    <div style="display: none;" id="gd">
    <div style="display: none;" id="ge">
    <div style="display: none;" id="gf">
    <div style="display: none;" id="gg">
    <div style="display: none;" id="gh">
    <div style="display: none;" id="gi">
    <div style="display: none;" id="gl">
    <div style="display: none;" id="gm">
    <div style="display: none;" id="gn">
    <div style="display: none;" id="gp">
    <div style="display: none;" id="gq">
    <div style="display: none;" id="gr">
    <div style="display: none;" id="gs">
    <div style="display: none;" id="gt">
    <div style="display: none;" id="gu">
    <div style="display: none;" id="gw">
    <div style="display: none;" id="gy">
    <div style="display: none;" id="hk">
    <div style="display: none;" id="hm">
    <div style="display: none;" id="hn">
    <div style="display: none;" id="hr">
    <div style="display: none;" id="ht">
    <div style="display: none;" id="hu">
    <div style="display: none;" id="id">
    <div style="display: none;" id="ie">
    <div style="display: none;" id="il">
    <div style="display: none;" id="im">
    <div style="display: none;" id="in">
    <div style="display: none;" id="io">
    <div style="display: none;" id="iq">
    <div style="display: none;" id="ir">
    <div style="display: none;" id="is">
    <div style="display: none;" id="it">
    <div style="display: none;" id="je">
    <div style="display: none;" id="jm">
    <div style="display: none;" id="jo">
    <div style="display: none;" id="jp">
    <div style="display: none;" id="ke">
    <div style="display: none;" id="kg">
    <div style="display: none;" id="kh">
    <div style="display: none;" id="ki">
    <div style="display: none;" id="km">
    <div style="display: none;" id="kn">
    <div style="display: none;" id="kp">
    <div style="display: none;" id="kr">
    <div style="display: none;" id="kw">
    <div style="display: none;" id="ky">
    <div style="display: none;" id="kz">
    <div style="display: none;" id="la">
    <div style="display: none;" id="lb">
    <div style="display: none;" id="lc">
    <div style="display: none;" id="li">
    <div style="display: none;" id="lk">
    <div style="display: none;" id="lr">
    <div style="display: none;" id="ls">
    <div style="display: none;" id="lt">
    <div style="display: none;" id="lu">
    <div style="display: none;" id="lv">
    <div style="display: none;" id="ly">
    <div style="display: none;" id="ma">
    <div style="display: none;" id="mc">
    <div style="display: none;" id="md">
    <div style="display: none;" id="me">
    <div style="display: none;" id="mf">
    <div style="display: none;" id="mg">
    <div style="display: none;" id="mh">
    <div style="display: none;" id="mk">
    <div style="display: none;" id="ml">
    <div style="display: none;" id="mm">
    <div style="display: none;" id="mn">
    <div style="display: none;" id="mo">
    <div style="display: none;" id="mp">
    <div style="display: none;" id="mq">
    <div style="display: none;" id="mr">
    <div style="display: none;" id="ms">
    <div style="display: none;" id="mt">
    <div style="display: none;" id="mu">
    <div style="display: none;" id="mv">
    <div style="display: none;" id="mw">
    <div style="display: none;" id="mx">
    <div style="display: none;" id="my">
    <div style="display: none;" id="mz">
    <div style="display: none;" id="na">
    <div style="display: none;" id="nc">
    <div style="display: none;" id="ne">
    <div style="display: none;" id="nf">
    <div style="display: none;" id="ng">
    <div style="display: none;" id="ni">
    <div style="display: none;" id="nl">
    <div style="display: none;" id="no">
    <div style="display: none;" id="np">
    <div style="display: none;" id="nr">
    <div style="display: none;" id="nu">
    <div style="display: none;" id="nz">
    <div style="display: none;" id="om">
    <div style="display: none;" id="pa">
    <div style="display: none;" id="pe">
    <div style="display: none;" id="pf">
    <div style="display: none;" id="pg">
    <div style="display: none;" id="ph">
    <div style="display: none;" id="pk">
    <div style="display: none;" id="pl">
    <div style="display: none;" id="pm">
    <div style="display: none;" id="pn">
    <div style="display: none;" id="pr">
    <div style="display: none;" id="ps">
    <div style="display: none;" id="pt">
    <div style="display: none;" id="pw">
    <div style="display: none;" id="py">
    <div style="display: none;" id="qa">
    <div style="display: none;" id="re">
    <div style="display: none;" id="ro">
    <div style="display: none;" id="rs">
    <div style="display: none;" id="ru">
    <div style="display: none;" id="rw">
    <div style="display: none;" id="sa">
    <div style="display: none;" id="sb">
    <div style="display: none;" id="sc">
    <div style="display: none;" id="sd">
    <div style="display: none;" id="se">
    <div style="display: none;" id="sg">
    <div style="display: none;" id="sh">
    <div style="display: none;" id="si">
    <div style="display: none;" id="sj">
    <div style="display: none;" id="sk">
    <div style="display: none;" id="sl">
    <div style="display: none;" id="sm">
    <div style="display: none;" id="sn">
    <div style="display: none;" id="so">
    <div style="display: none;" id="sr">
    <div style="display: none;" id="ss">
    <div style="display: none;" id="st">
    <div style="display: none;" id="sv">
    <div style="display: none;" id="sy">
    <div style="display: none;" id="sz">
    <div style="display: none;" id="tc">
    <div style="display: none;" id="td">
    <div style="display: none;" id="tf">
    <div style="display: none;" id="tg">
    <div style="display: none;" id="th">
    <div style="display: none;" id="tj">
    <div style="display: none;" id="tk">
    <div style="display: none;" id="tl">
    <div style="display: none;" id="tm">
    <div style="display: none;" id="tn">
    <div style="display: none;" id="to">
    <div style="display: none;" id="tr">
    <div style="display: none;" id="tt">
    <div style="display: none;" id="tv">
    <div style="display: none;" id="tw">
    <div style="display: none;" id="tz">
    <div style="display: none;" id="ua">
    <div style="display: none;" id="ug">
    <div style="display: none;" id="um">
    <div style="display: none;" id="us">
    <div style="display: none;" id="uy">
    <div style="display: none;" id="uz">
    <div style="display: none;" id="va">
    <div style="display: none;" id="vc">
    <div style="display: none;" id="ve">
    <div style="display: none;" id="vg">
    <div style="display: none;" id="vi">
    <div style="display: none;" id="vn">
    <div style="display: none;" id="vu">
    <div style="display: none;" id="wf">
    <div style="display: none;" id="ws">
    <div style="display: none;" id="xk">
    <div style="display: none;" id="ye">
    <div style="display: none;" id="yt">
    <div style="display: none;" id="za">
    <div style="display: none;" id="zm">
    <div style="display: none;" id="zw">
  • 05-04-2022, 17:03:28
    #3
    KAYNAKSOFTBT adlı üyeden alıntı: mesajı görüntüle
    <div style="display: none;" id="AD">
    <div style="display: none;" id="AE">
    <div style="display: none;" id="AF">
    <div style="display: none;" id="AG">
    <div style="display: none;" id="AI">
    <div style="display: none;" id="AL">
    <div style="display: none;" id="AM">
    <div style="display: none;" id="AO">
    <div style="display: none;" id="AQ">
    <div style="display: none;" id="AR">
    <div style="display: none;" id="AS">
    <div style="display: none;" id="AT">
    <div style="display: none;" id="AU">
    <div style="display: none;" id="AW">
    <div style="display: none;" id="AX">
    <div style="display: none;" id="AZ">
    <div style="display: none;" id="BA">
    <div style="display: none;" id="BB">
    <div style="display: none;" id="BD">
    <div style="display: none;" id="BE">
    <div style="display: none;" id="BF">
    <div style="display: none;" id="BG">
    <div style="display: none;" id="BH">
    <div style="display: none;" id="BI">
    <div style="display: none;" id="BJ">
    <div style="display: none;" id="BL">
    <div style="display: none;" id="BM">
    <div style="display: none;" id="BN">
    <div style="display: none;" id="BO">
    <div style="display: none;" id="BR">
    <div style="display: none;" id="BS">
    <div style="display: none;" id="BT">
    <div style="display: none;" id="BV">
    <div style="display: none;" id="BW">
    <div style="display: none;" id="BY">
    <div style="display: none;" id="BZ">
    <div style="display: none;" id="CA">
    <div style="display: none;" id="CC">
    <div style="display: none;" id="CD">
    <div style="display: none;" id="CF">
    <div style="display: none;" id="CG">
    <div style="display: none;" id="CH">
    <div style="display: none;" id="CI">
    <div style="display: none;" id="CK">
    <div style="display: none;" id="CL">
    <div style="display: none;" id="CM">
    <div style="display: none;" id="CN">
    <div style="display: none;" id="CO">
    <div style="display: none;" id="CR">
    <div style="display: none;" id="CU">
    <div style="display: none;" id="CV">
    <div style="display: none;" id="CX">
    <div style="display: none;" id="CY">
    <div style="display: none;" id="CZ">
    <div style="display: none;" id="DE">
    <div style="display: none;" id="DJ">
    <div style="display: none;" id="DK">
    <div style="display: none;" id="DM">
    <div style="display: none;" id="DO">
    <div style="display: none;" id="DZ">
    <div style="display: none;" id="EC">
    <div style="display: none;" id="EE">
    <div style="display: none;" id="EG">
    <div style="display: none;" id="EH">
    <div style="display: none;" id="ER">
    <div style="display: none;" id="ES">
    <div style="display: none;" id="ET">
    <div style="display: none;" id="FI">
    <div style="display: none;" id="FJ">
    <div style="display: none;" id="FK">
    <div style="display: none;" id="FM">
    <div style="display: none;" id="FO">
    <div style="display: none;" id="FR">
    <div style="display: none;" id="GA">
    <div style="display: none;" id="GB">
    <div style="display: none;" id="GD">
    <div style="display: none;" id="GE">
    <div style="display: none;" id="GF">
    <div style="display: none;" id="GG">
    <div style="display: none;" id="GH">
    <div style="display: none;" id="GI">
    <div style="display: none;" id="GL">
    <div style="display: none;" id="GM">
    <div style="display: none;" id="GN">
    <div style="display: none;" id="GP">
    <div style="display: none;" id="GQ">
    <div style="display: none;" id="GR">
    <div style="display: none;" id="GS">
    <div style="display: none;" id="GT">
    <div style="display: none;" id="GU">
    <div style="display: none;" id="GW">
    <div style="display: none;" id="GY">
    <div style="display: none;" id="HK">
    <div style="display: none;" id="HM">
    <div style="display: none;" id="HN">
    <div style="display: none;" id="HR">
    <div style="display: none;" id="HT">
    <div style="display: none;" id="HU">
    <div style="display: none;" id="ID">
    <div style="display: none;" id="IE">
    <div style="display: none;" id="IL">
    <div style="display: none;" id="IM">
    <div style="display: none;" id="IN">
    <div style="display: none;" id="IO">
    <div style="display: none;" id="IQ">
    <div style="display: none;" id="IR">
    <div style="display: none;" id="IS">
    <div style="display: none;" id="IT">
    <div style="display: none;" id="JE">
    <div style="display: none;" id="JM">
    <div style="display: none;" id="JO">
    <div style="display: none;" id="JP">
    <div style="display: none;" id="KE">
    <div style="display: none;" id="KG">
    <div style="display: none;" id="KH">
    <div style="display: none;" id="KI">
    <div style="display: none;" id="KM">
    <div style="display: none;" id="KN">
    <div style="display: none;" id="KP">
    <div style="display: none;" id="KR">
    <div style="display: none;" id="KW">
    <div style="display: none;" id="KY">
    <div style="display: none;" id="KZ">
    <div style="display: none;" id="LA">
    <div style="display: none;" id="LB">
    <div style="display: none;" id="LC">
    <div style="display: none;" id="LI">
    <div style="display: none;" id="LK">
    <div style="display: none;" id="LR">
    <div style="display: none;" id="LS">
    <div style="display: none;" id="LT">
    <div style="display: none;" id="LU">
    <div style="display: none;" id="LV">
    <div style="display: none;" id="LY">
    <div style="display: none;" id="MA">
    <div style="display: none;" id="MC">
    <div style="display: none;" id="MD">
    <div style="display: none;" id="ME">
    <div style="display: none;" id="MF">
    <div style="display: none;" id="MG">
    <div style="display: none;" id="MH">
    <div style="display: none;" id="MK">
    <div style="display: none;" id="ML">
    <div style="display: none;" id="MM">
    <div style="display: none;" id="MN">
    <div style="display: none;" id="MO">
    <div style="display: none;" id="MP">
    <div style="display: none;" id="MQ">
    <div style="display: none;" id="MR">
    <div style="display: none;" id="MS">
    <div style="display: none;" id="MT">
    <div style="display: none;" id="MU">
    <div style="display: none;" id="MV">
    <div style="display: none;" id="MW">
    <div style="display: none;" id="MX">
    <div style="display: none;" id="MY">
    <div style="display: none;" id="MZ">
    <div style="display: none;" id="NA">
    <div style="display: none;" id="NC">
    <div style="display: none;" id="NE">
    <div style="display: none;" id="NF">
    <div style="display: none;" id="NG">
    <div style="display: none;" id="NI">
    <div style="display: none;" id="NL">
    <div style="display: none;" id="NO">
    <div style="display: none;" id="NP">
    <div style="display: none;" id="NR">
    <div style="display: none;" id="NU">
    <div style="display: none;" id="NZ">
    <div style="display: none;" id="OM">
    <div style="display: none;" id="PA">
    <div style="display: none;" id="PE">
    <div style="display: none;" id="PF">
    <div style="display: none;" id="PG">
    <div style="display: none;" id="PH">
    <div style="display: none;" id="PK">
    <div style="display: none;" id="PL">
    <div style="display: none;" id="PM">
    <div style="display: none;" id="PN">
    <div style="display: none;" id="PR">
    <div style="display: none;" id="PS">
    <div style="display: none;" id="PT">
    <div style="display: none;" id="PW">
    <div style="display: none;" id="PY">
    <div style="display: none;" id="QA">
    <div style="display: none;" id="RE">
    <div style="display: none;" id="RO">
    <div style="display: none;" id="RS">
    <div style="display: none;" id="RU">
    <div style="display: none;" id="RW">
    <div style="display: none;" id="SA">
    <div style="display: none;" id="SB">
    <div style="display: none;" id="SC">
    <div style="display: none;" id="SD">
    <div style="display: none;" id="SE">
    <div style="display: none;" id="SG">
    <div style="display: none;" id="SH">
    <div style="display: none;" id="SI">
    <div style="display: none;" id="SJ">
    <div style="display: none;" id="SK">
    <div style="display: none;" id="SL">
    <div style="display: none;" id="SM">
    <div style="display: none;" id="SN">
    <div style="display: none;" id="SO">
    <div style="display: none;" id="SR">
    <div style="display: none;" id="SS">
    <div style="display: none;" id="ST">
    <div style="display: none;" id="SV">
    <div style="display: none;" id="SY">
    <div style="display: none;" id="SZ">
    <div style="display: none;" id="TC">
    <div style="display: none;" id="TD">
    <div style="display: none;" id="TF">
    <div style="display: none;" id="TG">
    <div style="display: none;" id="TH">
    <div style="display: none;" id="TJ">
    <div style="display: none;" id="TK">
    <div style="display: none;" id="TL">
    <div style="display: none;" id="TM">
    <div style="display: none;" id="TN">
    <div style="display: none;" id="TO">
    <div style="display: none;" id="TR">
    <div style="display: none;" id="TT">
    <div style="display: none;" id="TV">
    <div style="display: none;" id="TW">
    <div style="display: none;" id="TZ">
    <div style="display: none;" id="UA">
    <div style="display: none;" id="UG">
    <div style="display: none;" id="UM">
    <div style="display: none;" id="US">
    <div style="display: none;" id="UY">
    <div style="display: none;" id="UZ">
    <div style="display: none;" id="VA">
    <div style="display: none;" id="VC">
    <div style="display: none;" id="VE">
    <div style="display: none;" id="VG">
    <div style="display: none;" id="VI">
    <div style="display: none;" id="VN">
    <div style="display: none;" id="VU">
    <div style="display: none;" id="WF">
    <div style="display: none;" id="WS">
    <div style="display: none;" id="XK">
    <div style="display: none;" id="YE">
    <div style="display: none;" id="YT">
    <div style="display: none;" id="ZA">
    <div style="display: none;" id="ZM">
    <div style="display: none;" id="ZW">
    Çok teşekkürler. Nasıl yaptığınızı öğrenebilir miyim? Elimde bir kaç satır daha mevcut çünkü. Teşekkürler.
  • 05-04-2022, 17:04:55
    #4
    meteyilmaz adlı üyeden alıntı: mesajı görüntüle
    Çok teşekkürler. Nasıl yaptığınızı öğrenebilir miyim? Elimde bir kaç satır daha mevcut çünkü. Teşekkürler.
  • 05-04-2022, 17:06:34
    #5
    KAYNAKSOFTBT adlı üyeden alıntı: mesajı görüntüle
    Formül vs. kullandınız mı? Tam tekniğini öğretirseniz, ücretini de verebilirim. Teşekkürler.
  • 05-04-2022, 17:09:19
    #6
    Bu cevap, konu sahibi tarafından kabul edilebilir bir cevap olarak işaretlendi.
    A Hücresi: <div style="display: none;" id="
    B Hücresi: Ülke Kodu
    C Hücresi: ">

    B hücresine ilgili verilerinizi yapıştırın.
    A ve C hücresini aşağı doğru çoğaltın.
    Bu kadar.
  • 05-04-2022, 17:10:15
    #7
    KAYNAKSOFTBT adlı üyeden alıntı: mesajı görüntüle
    A Hücresi: <div style="display: none;" id="
    B Hücresi: Ülke Kodu
    C Hücresi: ">

    B hücresine ilgili verilerinizi yapıştırın.
    A ve C hücresini aşağı doğru çoğaltın.
    Bu kadar.
    Çok teşekkür ederim. İyi çalışmalar.
  • 05-04-2022, 17:10:49
    #8
    meteyilmaz adlı üyeden alıntı: mesajı görüntüle
    Çok teşekkür ederim. İyi çalışmalar.
    Rica ederim, size de iyi çalışmalar.