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...
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...
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...
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?
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