title: Using Gathering/Automating information from Excel sheets
body: <p>I have multiple Excel files with sheets that show bank account information in the picture. I want to show a daily beginning and ending balance for each account and also show a total of the transactions that took place on each account with a daily closing balance. What is a good way to go about doing this? The end result with be a sheet or a table with each daily closing amount and each total of the transactions that took place in the various daily accounts
  <img src="https://i.stack.imgur.com/elwEB.jpg" alt=" " /></p>