‘\u00a0 Sheets(“BUGUN”).Select<\/p>\n
\u00a0‘ Range(“H5”).Select<\/p>\n
\u00a0‘With Worksheets(“BUGUN”)<\/p>\n
‘ End With<\/p>\n
saycikan = 0<\/p>\n
\u00a0For Each BUGUN In Worksheets(“BUGUN”).Range(“H5:H10”)\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 For Each dun In Worksheets(“DUN”).Range(“H5:H10”)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ MsgBox “B” & BUGUN<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ‘MsgBox “D” & DUN<\/p>\n
‘ If BUGUN <> dun Then<\/p>\n
‘ CIKMI\u015e<\/p>\n
saycikan = saycikan + 1\u00a0<\/p>\n
\u00a0 Sheets(“CIKANLAR”).Select\u00a0<\/p>\n
‘ il se\u00e7im ba\u015flang\u0131c\u0131n\u0131 ayarl\u0131yoruz<\/p>\n
If saycikan = 1 Then<\/p>\n
\u00a0\u00a0 Range(“a1”).Select<\/p>\n
\u00a0 ‘ActiveCell = “=DUN!R[” & dun.Row & “]C”<\/p>\n
ActiveCell = “=VLOOKUP(BUGUN!R[4]C[7],DUN!R5C8:R500C9,2,0)”<\/p>\n
\u00a0End If<\/p>\n
\u00a0\u00a0 ActiveCell.Offset(1, 0).Select<\/p>\n
\u00a0\u00a0\u00a0 ‘ test = “=BUGUN!R[4” & dun.Row & “]C”<\/p>\n
\u00a0\u00a0\u00a0 ‘MsgBox test<\/p>\n
\u00a0\u00a0\u00a0 ‘ ActiveCell.FormulaR1C1 = “=DUN!R[” & dun.Row & “]C”<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ ActiveCell = “=VLOOKUP(BUGUN!H5;DUN!$H$5:$I$500;2;0)”\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 dunformul = “=VLOOKUP(BUGUN!R[4]C[” & dun & “],DUN!R4C7:R500C9,2,0)”<\/p>\n
\u00a0\u00a0\u00a0 ‘\u00a0 MsgBox (dun.Rows)<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ActiveCell = “=VLOOKUP(BUGUN!R[4]C[7],DUN!R5C8:R500C9,2,0)”<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ VLOOKUP(BUGUN!H5:H132;DUN!A:I;2;0)<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ =VLOOKUP(A2;MAHALLELER!$A$2:$B$5;2;0)<\/p>\n
\u00a0\u00a0\u00a0\u00a0 ‘ MsgBox dun.Row<\/p>\n
\u00a0 ‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ” =VLOOKUP(A:A;Sheet7!A:B;2;0)<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ End If<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Next dun<\/p>\n
Next BUGUN<\/p>\n","protected":false},"excerpt":{"rendered":"
‘ Sheets(“BUGUN”).Select<\/p>\n
‘ Range(“H5”).Select<\/p>\n
‘With Worksheets(“BUGUN”)<\/p>\n
‘ End With<\/p>\n
saycikan = 0<\/p>\n
For Each BUGUN In Worksheets(“BUGUN”).Range(“H5:H10”) <\/p>\n
For Each dun In Worksheets(“DUN”).Range(“H5:H10”) <\/p>\n
‘ MsgBox “B” & BUGUN<\/p>\n
‘MsgBox “D” & DUN<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[140,33],"tags":[],"class_list":["post-811","post","type-post","status-publish","format-standard","hentry","category-ms-excel","category-office","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":2495,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=811"}],"version-history":[{"count":0,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/811\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}