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
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
Watch the video to see how. Let me know if you have questions or require clarification.