# month

1. ### Formula that cumulatively adds months based on start and end date

Hi, First time posting on here so apologies if my request has anything missing. I have a list of projects, each with a start and end date in one excel sheet. In another sheet I have months as the column headers, and rows containing "new projects" and "active projects". I have filled out the...
2. ### Month Conditional Formatting

If a range in a column contains a specific month using the format Mon-01 June 2020 then I want to set conditional formatting on that range. Different conditional formatting would apply for each of the other 12 months, plus the one column “R” labeled “Expected Conversion \$ To Kč” would have the...
3. ### Dates to month with if conditions

Hi All, Thanks in advance, we have the following sheets sheet1 Time and dateEmail AddressOptiontest5-5-2020 12:52:30goldy@zyx.comcall15-5-2020 12:58:38vin@fdfs.comcall 25-5-2020 13:14:23pate@dfd.comcall1Option 15-5-2020 13:15:34lucy@fdfd.comcall35-5-2020 13:25:03goldy@zyx.comcall26-9-2020...
4. ### Format decimal as number of months

Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
5. ### Monthly increase

I need a formula in my excel sheet that increases in value by 2.16 every month. e.g. if cell A2 is "5" in January it must automaticly be "7.16" the first of February and "9.32" the first of March and so on. Is there any formula to make this happen? If a parameter to get yesterdays month existed...
6. ### VBA Match Month & Year in Row to Month & Year from another cell

Thanks in advance for any help! I'm trying to locate the month and year contained in a row of one worksheet that matches the month and year contained in a cell on a different worksheet. Then copy the matching column to a third worksheet. With the below, I'm receiving a "Type Mismatch" error on...
7. ### Month Sum based and dates and a name

I have a spreadsheet called "Scrap Detail" where we log what items we scrap and against what work cell. Column A has the date and column B has a drop down to select the Cell. The value of the scrap is then totalled in Column F. We then have different work cells within the business where I have...
8. ### IF Last month

Hi Guys, I think this is pretty basic, yet I still havent been able to figure it out. I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA. A1 has date B1 has value I wanted formula to capture C1...
9. ### averaging months

what i want to do is. i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week. Example: week 1...
10. ### Formulas

Hi I have a Workbook which has a sheet for each month and a totals sheet. I'm trying to get Year to Date totals based on the month. ie in cell E1 on the Master Doc tab the month is Jan then in C5 it shows the value from C5 on the Jan tab. If E1 is changed to June 19 I want C5 to show the Total...
11. ### Count unique number in column B for specified month.

Hi All, I'm wondering if someone could help me on this! Is it possible to add month instead of range. Like count unique number in column B for the month of Sep, Oct or Nov. Note that I have column C which has dated when claim number was issued. A B Test-Count | Auto-Num...
12. ### Pop up message box

Hello all, I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...
13. ### VBA AutoOpen sub to worksheet # based upon the current month

Good EveningEveryone :), I would like to create an AutoOpen sub that automatically opens up to a specific worksheet based upon the current month. For example, we are currently in October, so I'd like it to open up toWorksheets(4). If its November, I'd like it to open up to Worksheets(5). If...
14. ### averaging months

I have a situation where i have 12 months in a row acroos my worksheet.( Jan-Dec), and i have 6 catgories with total number of students that attend across the top. each month has 4 dates. so what you have is each month they meet weekly and i have a attendance number. I another place on the...
15. ### set up blank pivot tables for future

folks, I am trying to set up a model that will report for the next twelve months. Each month is on a separate worksheet. I need to show salesperson and sales amount in one of the graphs. Given that sales people may or may not achieve a sale in any one month, I thought that using a pivot table...
16. ### Case Statement and For next loop

Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
17. ### Could you check my code, userform to worksheet please

Hi, The code is shown below. I have a userform with Comboboxes ComboBox1 is MONTH ComboBox2 is YEAR Month is to be inserted into cell A3 Year is to be inserted into cell C3 When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3 Please can...
18. ### Advice for code copy / paste userform to cell range

On my worksheet called Sheet1 i have a range I26:I35 with values in. My intensions are to press a transfer button on a userform & select a Month. This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
19. ### Countif Month for Attendance Sheet

I am making an attendance sheet to count the number of times a person is present in a certain month. (url to photo of sheet attached) Column A is Dates, and Columns C-D lists "yes" if present on that date and "no" if not present on that date. Column G lists months (Feb, Mar, April..), and in...
20. ### Vlookup to a sheet in a workbook that changes each month

Hi everyone I have learnt so many tricks from this forum which has made my job much easier. I have another "challenge" now: I have inheriated a workbook with many cells lookup to a worksheet in another workbook, it is simply, however, the worksheet changes each month, for example, in Oct the...

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...