december

Hello- I would like a macro to copy an entire row of data, based on month of transaction. I have identical headers from Row 1-6 and column A, on the register sheet and each month sheet (January, February, March, etc" Data is in sheet "Register" from B7:AC500. The date for each transaction is...

Hi, I have 30 agents working in 3 different shifts ( morning, evening and night). After completing their work each of them have to submit there tracker in a specified folder. At the shift end one person has to collate the data from all the workbooks( sheet 1) and paste it in a new excel and...

How can I "drag" down dates formatted as below to auto update? <tbody> November 2016 December 2016 January 2017 February 20217 March 2017 April 2017 </tbody>

Hi, I want to list sequentially all working dates between two dates inclusively. So in A1 I have start date and A2 end date. In B1 would be the first working date, B2 the second working date and so on until it reached the end date. example. Start: 22nd December 2017 End: 28th December 2017...

Hi all, I wondered if there is a way of creating automated charts without using dynamic ranges? In the past I've used formula similar to Chart the Last 12 Months Dynamically but this time I have a lot more datasets to plot and creating all the range names will take a while. The data I have is...

Hello All My question this afternoon, Is there an alternate way to average December January & February The formula I am using is ={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))} <tbody> January 25...

Hello, If I know the month = 12 and Year = 2017, how do I convert to "December 31, 2017"? Thanks in advance!!

Hi! I need to protect the sheet except for specific columns where input is still needed based on the current month. Columns N to Y represents the months January to December. So, columns T to Y (July to December) need to be active because those months are still coming. When the month of August...