{"id":295,"date":"2013-10-05T12:24:13","date_gmt":"2013-10-05T12:24:13","guid":{"rendered":"http:\/\/dijitalturk.com\/veysel\/?p=295"},"modified":"2024-12-19T20:30:28","modified_gmt":"2024-12-19T20:30:28","slug":"excell-sayfa-birlestirme-sheet-import-macro","status":"publish","type":"post","link":"https:\/\/dijitalturk.com\/veysel\/excell-sayfa-birlestirme-sheet-import-macro\/","title":{"rendered":"Excell Sayfa birle\u015ftirme (Sheet import with macro)"},"content":{"rendered":"<p>Farkl\u0131 excell dosyalar\u0131nda bulunan sayfalar\u0131 tek bir excell dosyas\u0131nda, tek bir sayfada birle\u015ftiren program, Excell Sayfa birle\u015ftirme yada Excell dosya birle\u015ftirme de diyebiliriz.<\/p>\n<p>Ek \u00f6zellikleri:<\/p>\n<ul>\n<li>ister sayfa s\u0131ras\u0131, ister sayfa ismine g\u00f6re birle\u015ftirme,<\/li>\n<li>Ko\u015ful tan\u0131mlama (\u00f6r: belirli bir h\u00fccrenin de\u011feri x olursa al)<\/li>\n<li>Hatalar\u0131 kaydetme<\/li>\n<li>ingilizce destekli (Supported English)<\/li>\n<\/ul>\n<p>Makrolu oldu\u011fu i\u00e7in \u00f6n izlemede g\u00f6remeyebilirsiniz. indirmek i\u00e7in a\u015fa\u011f\u0131daki &#8220;<strong>download \/ \u0130ndir<\/strong>&#8221; link&#8217;ini t\u0131klayabilirsiniz.<\/p>\n<p>Bu excel sayfa birle\u015ftirme macro uygulamas\u0131 ile neler yapabilirsiniz;<\/p>\n<p>y\u00fczlerce excel dosyan\u0131z olabilir, bu dosyalar\u0131n i\u00e7erisinde onlarca excel sheet&#8217;iniz olabilir. t\u00fcm bu verileri tek bir excel dosyas\u0131n\u0131n i\u00e7inde hatta tek bir sheet&#8217;in i\u00e7erisinde belirli ko\u015fullar\u0131 sa\u011fl\u0131yorsa gibi komutlar ekleyerek birle\u015ftirme i\u015flemi yapabilirsiniz.<\/p>\n<p>Bunun i\u00e7in video \u00e7ekece\u011fimi yazm\u0131\u015ft\u0131m ama hala \u00e7ekmedim biliyorum ama hala akl\u0131mda vakit buldu\u011fum ilk f\u0131rsatta Excel Sayfa Birle\u015ftirme uygulamas\u0131 i\u00e7in bir anlat\u0131m videosu \u00e7ekece\u011fim.<\/p>\n<p>Bu uygulamay\u0131 eski \u00e7al\u0131\u015ft\u0131\u011f\u0131m i\u015f yerinde i\u015flerimi kolayla\u015ft\u0131rs\u0131n diye tasarlam\u0131\u015ft\u0131m ve o d\u00f6nem resmen hayat\u0131m\u0131 kurtarm\u0131\u015ft\u0131. Umar\u0131m sizlere de faydas\u0131 olur.<\/p>\n<p>L\u00fctfen Excel Sayfa Birle\u015ftirme uygulamas\u0131n\u0131 payla\u015facaksan\u0131z DijitalTurk.com&#8217;\u00fc kaynak g\u00f6stermeyi unutmay\u0131n\u0131z.<\/p>\n<p>Sayfa birle\u015ftirme excel macro uygulamas\u0131 makro i\u00e7erdi\u011fi i\u00e7in ve uzant\u0131s\u0131 .xlsm oldu\u011fu i\u00e7in a\u015fa\u011f\u0131daki \u00f6nizleme alan\u0131nda g\u00f6r\u00fcnmeyecektir ama &#8220;\u0130ND\u0130R&#8221; yazan yere t\u0131klarsan\u0131z indirebilirsiniz.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/drive.google.com\/file\/d\/1LserDs6D_3qdP5jVy8H-qWLKbqJaaJzz\/view?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u0130ND\u0130R<\/a><\/span><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>Farkl\u0131 excell dosyalar\u0131nda bulunan sayfalar\u0131 tek bir excell dosyas\u0131nda, tek bir sayfada birle\u015ftiren program, Excell Sayfa birle\u015ftirme yada Excell dosya [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":576,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[345,2],"tags":[151,152,71],"class_list":["post-295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-yazilim","tag-excell","tag-macro","tag-visual-basic"],"uagb_featured_image_src":{"full":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"thumbnail":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA-150x150.png",150,150,true],"medium":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA-190x190.png",190,190,true],"medium_large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"1536x1536":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"2048x2048":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false]},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":9,"uagb_excerpt":"Farkl\u0131 excell dosyalar\u0131nda bulunan sayfalar\u0131 tek bir excell dosyas\u0131nda, tek bir sayfada birle\u015ftiren program, Excell Sayfa birle\u015ftirme yada Excell dosya [&hellip;]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media\/576"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}