Warning: Use of undefined constant style - assumed 'style' (this will throw an Error in a future version of PHP) in /home1/tayoswdg/public_html/sdnuggets/wp-content/themes/ThrillingTheme0/functions.php on line 522
617 views

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]

Last Sunday, I was unable to send out this update to members of my Excel Heaven Visual Basic Automation club, due to continuing connectivity challenges that caused a backlog of tasks.
 
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.
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.
 
Below: I commence constructing the syntax for the TRANSPOSE function

imprest-cb-transpose

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

imprest-cb-transpose2

Watch the video to see how. Let me know if you have questions or require clarification.


Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.