current month

  1. E

    Count If Month is Current Month

    Here is the Issue I have 3 Pie Charts, they are populated from a spreadsheet that has a Status page (pie charts are located there), and the status page is updated from 3 additional sheets from the spreadsheet. I need the pie charts to only update with the current month data only, the sums of...
  2. W

    VBA Macro to Copy Row Based on Date Criteria

    Greetings MrExcel forum members. I'm a beginner when it comes to writing macros and have used this source before, but I'm having trouble with a new macro. Any help this amazing community can provide will be greatly appreciated. My boss wants a monthly report listing all personnel that are...
  3. G

    Search and replace current month with last & and save as macro

    Hello there folks! I need help with a code that will save the opel file as "jan-current month_current year". And I need the month to appear as text with three letters, for example it would be "jan-jun_2015" if I run the macro now. Is this possible to do? Also when I use the search and...
  4. S

    Conditional Formatting for month only

    I'm trying to have a cell highlight red if it is the current month, orange if next month. The actual input is text exa "January". Not a date. Is there a way where we can do this to where it will always highlight the current month even if the sheet is viewed in say... March?
  5. K

    Change color of current month only...

    Thank you for your help in the past! Step 1: In cell B1, my VBA puts the # of the current month using MONTH(TODAY()). This can change if you know a better way. Step 2: In column B2:B20, there are random 3 letter months B2 = FEB B3 = MAR B4 = AUG B5 = FEB B6 = DEC B7 = JAN B8 = AUG B9 = JAN etc...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top