MrExcel Message Board

This Week's Hot Topics

• Filter multiple worksheets based on list

  • Started by alkaline55
  • Friday at 1:40 PM
  • Replies: 36

  Hi everyone, I'm new to VBA and looking for some guidance. I'd like to filter Column A on three different tabs based on the first value of a list...
• Calling a Macro pretty simple yet...

  • Started by erutherford
  • Saturday at 8:13 PM
  • Replies: 31

  I have a form that enters data in Col A, B, C. A macro runs next that groups the data into Col D Here is the macro ( runs fine manually) [code]...
• VBA & Conditional Format

  • Started by Patriot2879
  • Jan 20, 2020
  • Replies: 30

  Hi good afternoon, 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...
• Complex Heat Map using conditional formatting

  • Started by Corried
  • Jan 20, 2020
  • Replies: 30

  Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Filtering data VBA with 3 criteria

  • Started by cortexnotion
  • Jan 22, 2020
  • Replies: 29

  Good Morning, I stumbled across this forum through some research and I was hoping you could help me with some VBA code. I have a data set...
• VBA copy data from multiple worksheets and paste in a specific, preformatted sheet.

  • Started by Pettel
  • Thursday at 3:32 PM
  • Replies: 29

  Hi everyone, I'm trying to gather information from multiple worksheets into a single preformatted table. I've started with a dialog folder picker...