bank

Hi Guys, I was just wondering if anyone knows how to exclude UK Bank Holidays from Networkdays? ideally using a formula or select case? Many thanks Jamie

Hi, I have a worksheet with multiple bank statement all combined together and sorted by date. Column E has the date, Column H has Debits and Column I has Credits, Row 1 has headers. I am trying to find a way of identifying debits and credits within a week of each other where the amount is the...

Hello, I am trying to match checks that hit the bank to checks in our accounting system by using the dollar amounts using a macro. I need it to: -Copy columns 1-10 in Sheet1 (Bank) and past it into Sheet3 corresponding columns. -It should do a lookup to the "Debit Amt" from Sheet2 (Accounting...

Microsoft Excel Macro for Automatic Bank Reconciliation Statement Dear Friends, I'm sharing Microsoft Excel Macro for Bank Reconciliation Statement developed by me Download the Macro Enabled Excel file from below link Open the “Book Sheet” and copy paste the Bank Ledger in your Books...

I would like to write VBA code to log into the below (and other) sites. I would like to then navigate within those sites (clicking links) to get to different pages where I would eventually be able to download Year to Date Statements. I am struggling with determining which commands to use in...

I am wonder if anyone else has run into issues when downloading mass banking transaction tables which are in the mm-dd-yyyy format. My issue is that my Excel (2007) is recognizing these dates as being dd-mm-yyyy; hence errors after the 12th day of a month and the wrong month on top of that. I...