{"id":12332,"date":"2017-07-17T04:56:36","date_gmt":"2017-07-17T04:56:36","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=12332"},"modified":"2017-07-17T04:56:36","modified_gmt":"2017-07-17T04:56:36","slug":"part-3-how-i-built-my-automated-cash-bookbank-reconciliation-software-building-the-imprest-cash-book-by-using-transpose-function-to-add-auto-updating-expense-headscost-centre-titles","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/part-3-how-i-built-my-automated-cash-bookbank-reconciliation-software-building-the-imprest-cash-book-by-using-transpose-function-to-add-auto-updating-expense-headscost-centre-titles\/","title":{"rendered":"Part 3 - How I Built My Automated Cash Book\/Bank Reconciliation Software\" [Building the Imprest Cash Book by Using TRANSPOSE Function to Add Auto-Updating Expense Heads\/Cost Centre Titles]"},"content":{"rendered":"<div><em>Last Sunday, I was unable to send out this update\u00a0to members of my Excel Heaven Visual Basic Automation club, due to continuing connectivity challenges that caused a backlog of tasks.<\/em><\/div>\n<div><em>\u00a0<\/em><\/div>\n<div>This week, in part 3 of the step-by-step video tutorial.....I demonstrate how I Built the Imprest Cash Book in this Automated Cash Book, by Using TRANSPOSE Function to Add Auto-Updating Expense Heads\/Cost Centre Titles tapping from a SETTINGS table I created before hand.<\/div>\n<div><\/div>\n<div><em>I just NOW sent out the video along with the example workbook used in the video, to all members via email - so see your inboxes.<\/em><\/div>\n<div><em>\u00a0<\/em><\/div>\n<div><strong>Below: I commence constructing the syntax for the TRANSPOSE function<\/strong><\/div>\n<div>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose.png\" rel=\"attachment wp-att-12333\"><img decoding=\"async\" class=\"alignnone size-full wp-image-12333\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose.png\" alt=\"imprest-cb-transpose\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose.png 1164w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose-300x196.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose-768x502.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose-1024x669.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose-150x98.png 150w\" sizes=\"(max-width: 1164px) 100vw, 1164px\" \/><\/a><\/p>\n<p><strong>Below: I highlight the vertical range of cells (holding Expense Heads\/Cost Centre titles) in the SETTINGS table to complete construction of the TRANSPOSE formula<\/strong><\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose2.png\" rel=\"attachment wp-att-12334\"><img decoding=\"async\" class=\"alignnone size-full wp-image-12334\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose2.png\" alt=\"imprest-cb-transpose2\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose2.png 662w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose2-261x300.png 261w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-transpose2-130x150.png 130w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/a><\/p>\n<\/div>\n<p>Watch the video to see how. Let me know if you have questions or require clarification.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last Sunday, I was unable to send out this update\u00a0to members of my Excel Heaven Visual Basic Automation club, due to continuing connectivity challenges that caused a backlog of tasks. \u00a0 This week, in part 3 of the step-by-step video tutorial.....I demonstrate how I Built the Imprest Cash Book in this Automated Cash Book, by [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,1375,266],"tags":[3014,3013],"class_list":["post-12332","post","type-post","status-publish","format-standard","hentry","category-entrepreneurs","category-excel-vb-solutions","category-my-dn-travel-news","tag-building-the-imprest-cash-book-by-using-transpose-function-to-add-auto-updating-expense-headscost-centre-titles","tag-part-3-how-i-built-my-automated-cash-bookbank-reconciliation-software"],"aioseo_notices":[],"views":849,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=12332"}],"version-history":[{"count":2,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12332\/revisions"}],"predecessor-version":[{"id":12336,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12332\/revisions\/12336"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=12332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=12332"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=12332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}