banking

  1. V

    Macro taking long time to execute.

    Hi all, Have to generate 640 files basis district name. The output sheets are formula based , they pull the data from input sheets. Mostly the sumifs formula is used. It takes almost 5 minutes to generate one single file. Perhaps with each change of district the calculation features takes time...
  2. J

    Power Query/M conditional row sums based on previous rows

    I have a data set containing dates and amounts for upcoming, cash flow causing accounts payable and accounts receivable transactions. Those are exported from accounting software and I use them for cash flow forecast. Other transactions are added manually to the forecast. Problem with those...
  3. J

    VBA - Macro for making banking file quicker to work with

    Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...
  4. J

    VBA - Macro for making banking file quicker to work with

    Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...
  5. M

    ModelOff 2014 - starts 25th October!

    Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
  6. D

    Filtering content from one spreadsheet to show it in another

    I am creating an Excel spreadsheet designed to manage my company's accounts. Spreadsheet 1 is used like a bank statement to show payments going in and out of the company's bank account. Spreadsheet 2 is used as a cash flow chart. The sheet sis divided into left and right. Columns on the left...
  7. B

    Banking, account categories, creating breakdown $ spent on each category

    GOAL: Create table of debit card transactions, by month and organized into summed categories (food, entertainment, education, etc.), each of which being compared to income for that month (percentage of) WHAT I KNOW: - If statements (haven't ever used them in excel though) - basics of excel -...
  8. S

    applying categories to bank transactions

    Windows XP, Excel 2007 Okay, Column A is filled with bank transaction descriptions like: 123456789 ACCOUNT WITHDRAWL CHECK CARD 1234 GOODY'S CLOTHING CHECK CARD 5678 APPLEBEES RESTAURANT 123456789876 SOU WAL-MART 092834750298 SOU JCPENNYS STORE 20938209837 ... AND SO ON Column B is the...

Some videos you may like

This Week's Hot Topics

Top