MrExcel Message Board

This Week's Hot Topics

• Payment term and Cash flow (formula linked with costs)

  • Started by Adfinance
  • Jan 1, 2021
  • Replies: 43

  Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I...
• Match to a list with wildcards

  • Started by The Gent
  • Dec 29, 2020
  • Replies: 29

  Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet...
• Inserting text above first blank row then above third blank row etc.

  • Started by Livin404
  • Jan 2, 2021
  • Replies: 24

  Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I...
• code to get students marks from source sheet to destination sheet.

  • Started by rzml
  • Dec 30, 2020
  • Replies: 22

  hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I...
• Run VBA on all open tabs

  • Started by Dannottheman
  • Dec 30, 2020
  • Replies: 22

  Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I...
• Functions to separate a string separated by commas

  • Started by jeffdolton
  • Jan 3, 2021
  • Replies: 22

  Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...