MrExcel Message Board

This Week's Hot Topics

• populate from drop list with multiple tables

  • Replies: 49
  • Jan 17, 2020

  Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba

  • Replies: 37
  • Saturday at 5:39 PM

  Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought

  • Replies: 35
  • Jan 15, 2020

  Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
• Listbox Header

  • Replies: 35
  • Jan 14, 2020

  Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
• Complex Heat Map using conditional formatting

  • Replies: 30
  • Monday at 10:04 AM

  Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Conditional formatting

  • Replies: 25
  • Monday at 5:21 AM

  Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...