{"id":12418,"date":"2017-07-24T02:53:06","date_gmt":"2017-07-24T02:53:06","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=12418"},"modified":"2017-07-24T02:53:06","modified_gmt":"2017-07-24T02:53:06","slug":"part-4-how-i-built-my-automated-cash-bookbank-reconciliation-software-adding-in-cell-drop-down-menus-to-reduce-user-data-entry-errors-in-the-imprest-cash-book","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/part-4-how-i-built-my-automated-cash-bookbank-reconciliation-software-adding-in-cell-drop-down-menus-to-reduce-user-data-entry-errors-in-the-imprest-cash-book\/","title":{"rendered":"Part 4 - How I Built My Automated Cash Book\/Bank Reconciliation Software [Adding In-Cell Drop Down Menus to Reduce User Data Entry Errors In The Imprest Cash Book]"},"content":{"rendered":"<div><span style=\"font-size: large;\"><b>Part 4 - How I Built My Automated Cash Book\/Bank Reconciliation Software [Adding In-Cell Drop Down Menus to Reduce User Data Entry Errors In The Imprest Cash Book]<\/b><\/span><\/div>\n<div><\/div>\n<div>\n<div>The following files have been emailed to members of my Excel Heaven Visual Basic Automation club - to be used for\u00a0their review of this week's tutorial:<\/div>\n<div><\/div>\n<div><strong>[1[ Step by Step screenshot video tutorial\u00a0(screenshot below)<\/strong><\/div>\n<div><strong>\u00a0<\/strong><\/div>\n<div><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2.png\" rel=\"attachment wp-att-12420\"><img decoding=\"async\" class=\"alignnone size-full wp-image-12420\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2.png\" alt=\"imprest-cb-in-cell-drop-menus2\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2.png 1280w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2-300x188.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2-768x480.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2-1024x640.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus2-150x94.png 150w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/div>\n<div><\/div>\n<div><strong>[2] Example workbook used in the video demonstration, complete with the new features\/functions added (screenshot below)<\/strong><\/div>\n<div><strong>\u00a0<\/strong><\/div>\n<div><img decoding=\"async\" class=\"alignnone size-full wp-image-12419\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus.png\" alt=\"imprest-cb-in-cell-drop-menus\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus.png 1280w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus-300x188.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus-768x480.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus-1024x640.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/07\/imprest-cb-in-cell-drop-menus-150x94.png 150w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/div>\n<div>Let me know if you need any help replicating or putting the demonstrated concepts into use,<\/div>\n<div><\/div>\n<div>In your service<\/div>\n<div><\/div>\n<div>Tayo<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Part 4 - How I Built My Automated Cash Book\/Bank Reconciliation Software [Adding In-Cell Drop Down Menus to Reduce User Data Entry Errors In The Imprest Cash Book] The following files have been emailed to members of my Excel Heaven Visual Basic Automation club - to be used for\u00a0their review of this week's tutorial: [1[ [&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,10],"tags":[3034,3033,3032],"class_list":["post-12418","post","type-post","status-publish","format-standard","hentry","category-entrepreneurs","category-excel-vb-solutions","category-my-dn-travel-news","category-self-development","tag-adding-in-cell-drop-down-menus-to-reduce-user-data-entry-errors-in-the-imprest-cash-book","tag-how-i-built-my-automated-cash-bookbank-reconciliation-software","tag-part-4"],"aioseo_notices":[],"views":960,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12418","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=12418"}],"version-history":[{"count":1,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12418\/revisions"}],"predecessor-version":[{"id":12421,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12418\/revisions\/12421"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=12418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=12418"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=12418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}