Hi Karen From my understanding, you wanted a count As At a certain month (after deducting Ended students) i.e. if 98 students joined in Sept'16 ...
Hi mey Can you please mark all posts that I have assisted you as Answered once you are satisfied with the solutions? Thanks Sunny
Hi Karen See if this helps. I don't have sufficient data to test but the 1st part (Sept and before) looks OK. I am using UK date (dd/mm/yyyy). C...
Hi Learning2 Try changing the following Set SummarySheet = Workbooks.Add(xlWBATWorksheet).Worksheets(1) to Set SummarySheet = ActiveWorkbook....
Try this Sunny
Hi Brooke The formula should not change if it is just sorting the data. If it is changing, then maybe you can attach a sample for us to take a l...
Hi mey See if this helps. Sunny
Hi mey Give this a try. Sunny
You can use a formula such as =A1&"-"&B1 where A1 and B1 contains numbers. or even =CONCATENATE(A1,"-",B1) Sunny
Give this a try. Sunny
Hi mey Try this. Sunny
Hi Give this a try. In cell B2 enter =SUMIF($C$1:$BY$1,">"&TODAY(),C2:BY2). Copy the formula down as many rows as needed. It will sum ...
Hi Hooi Thin Please ignore my remarks about hiding the blank caption slicer using Excel 2013. It won't work in this situation.Although the caption ...
Hi Catalin Thanks for your lengthy explanation I do have codes that will disconnect all slicers (irrespective of data source) in a workbook and...
Hi Hooi Thin Your request is very tough to do and very challenging. I have somehow did something like what you needed but it is quite complex. I...