{"id":30325,"date":"2023-01-14T13:56:35","date_gmt":"2023-01-14T08:26:35","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/"},"modified":"2023-01-14T13:56:35","modified_gmt":"2023-01-14T08:26:35","slug":"solved-copying-and-pasting-between-workbooks-vba","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/","title":{"rendered":"[Solved] Copying and Pasting between Workbooks VBA"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-41102539\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"41102539\" data-parentid=\"41102348\" data-score=\"2\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>As you have supplied no code, this should be sufficient enough to get you started. You&#8217;ll need to edit this and fix this to suite your needs.<\/p>\n<pre><code>Sub test()\n    Dim Wb1 As Workbook, Wb2 As WorkBook, Wb3 As Workbook\n    Dim MainBook As Workbook\n\n    'Open All workbooks first:\n    Set Wb1 = Workbooks.Open(\" path to copying book \")\n    Set Wb2 = Workbooks.Open(\" path to copying book \")\n    Set Wb3 = Workbooks.Open(\" path to copying book \")\n    Set MainBook = Workbooks.Open(\" path to destination book \")\n\n    'Now, copy what you want from wb1:\n    wb1.Sheets(\"Sheet1\").Cells.Copy\n    'Now, paste to Main worksheet:\n    MainBook.Sheets(\"Sheet1\").Range(\"A1\").PasteSpecial\n\n    'Now, copy what you want from wb2:\n    wb2.Sheets(\"Sheet1\").Cells.Copy\n    'Now, paste to Main worksheet:\n    MainBook.Sheets(\"Sheet2\").Range(\"A1\").PasteSpecial\n\n    'Now, copy what you want from wb3:\n    wb3.Sheets(\"Sheet1\").Cells.Copy\n    'Now, paste to Main worksheet:\n    MainBook.Sheets(\"Sheet3\").Range(\"A1\").PasteSpecial\n\n    'Close Wb's:\n    Wb1.Close\n    Wb2.Close\n    Wb3.Close\n    MainBook.Save\n    MainBook.Close\n\nEnd Sub\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Copying and Pasting between Workbooks VBA <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] As you have supplied no code, this should be sufficient enough to get you started. You&#8217;ll need to edit this and fix this to suite your needs. Sub test() Dim Wb1 As Workbook, Wb2 As WorkBook, Wb3 As Workbook Dim MainBook As Workbook &#8216;Open All workbooks first: Set Wb1 = Workbooks.Open(&#8221; path to copying &#8230; <a title=\"[Solved] Copying and Pasting between Workbooks VBA\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\" aria-label=\"More on [Solved] Copying and Pasting between Workbooks VBA\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[5735,400,401],"class_list":["post-30325","post","type-post","status-publish","format-standard","hentry","category-solved","tag-copy-paste","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Copying and Pasting between Workbooks VBA - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Copying and Pasting between Workbooks VBA - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] As you have supplied no code, this should be sufficient enough to get you started. You&#8217;ll need to edit this and fix this to suite your needs. Sub test() Dim Wb1 As Workbook, Wb2 As WorkBook, Wb3 As Workbook Dim MainBook As Workbook &#039;Open All workbooks first: Set Wb1 = Workbooks.Open(&quot; path to copying ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-14T08:26:35+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Copying and Pasting between Workbooks VBA\",\"datePublished\":\"2023-01-14T08:26:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\"},\"wordCount\":44,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"copy-paste\",\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\",\"name\":\"[Solved] Copying and Pasting between Workbooks VBA - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-14T08:26:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Copying and Pasting between Workbooks VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Copying and Pasting between Workbooks VBA - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Copying and Pasting between Workbooks VBA - JassWeb","og_description":"[ad_1] As you have supplied no code, this should be sufficient enough to get you started. You&#8217;ll need to edit this and fix this to suite your needs. Sub test() Dim Wb1 As Workbook, Wb2 As WorkBook, Wb3 As Workbook Dim MainBook As Workbook 'Open All workbooks first: Set Wb1 = Workbooks.Open(\" path to copying ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/","og_site_name":"JassWeb","article_published_time":"2023-01-14T08:26:35+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Copying and Pasting between Workbooks VBA","datePublished":"2023-01-14T08:26:35+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/"},"wordCount":44,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["copy-paste","excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/","url":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/","name":"[Solved] Copying and Pasting between Workbooks VBA - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-14T08:26:35+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-copying-and-pasting-between-workbooks-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Copying and Pasting between Workbooks VBA"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=30325"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30325\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=30325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=30325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=30325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}