MrExcel Message Board

This Week's Hot Topics

• VBA code to pick data based on multiple conditions

  • Started by tirumal
  • Feb 16, 2020
  • Replies: 89

  Hello guys, I've been struggling to write this for days macro and I have finally decided to ask for your help. [B]Here's what I have:[/B]...
• Code optimization required - run all processes in memory before placing result to worksheet

  • Started by kelly mort
  • Tuesday at 2:55 PM
  • Replies: 32

  I need to get these codes run in memory for the various processes, before placing the result onto the sheet instead on interacting with the sheet...
• Fill Cell based on Specific Row and Column Text

  • Started by temerson
  • Monday at 11:24 AM
  • Replies: 29

  Hello, I have a matrix and want to create a code if it finds a specific text in a column (Column F) and row (Row 3), it will fill a cell starting...
• Adding rows based on comma value

  • Started by smashclash
  • Feb 16, 2020
  • Replies: 26

  I have a set of data like below that I need to separate out. Rather than the data be broken out for each single instance of a name it's grouped...
• VBA code giving errors and stopping Excel

  • Started by steve400243
  • Feb 13, 2020
  • Replies: 26

  Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
• Copy a worksheet and rename it to the project name in a given cell.

  • Started by Jay3
  • Tuesday at 12:08 PM
  • Replies: 26

  Hi All, I have a sheet called "new project requiring board". in column H I have a Yes/No drop down validation list. If the user selects yes I...