activities

Hi, I am trying to make a process a little easier at the school I work in. 1 hour a week we have an enrichment time where different activities are offered to the children on a 6 week basis, they pick their preferences on a slip, then 2 staff members sift through all the slips and allocate them...

When I open my spreadsheet and delete contents out of a cell, I get a type mismatch error. This is my code: Private Sub Worksheet_Change(ByVal Target As Range) 'ActiveSheet.Unprotect Dim ans As String If Not Intersect(Target, Range("A:A,B:B")) Is Nothing Then...

Hello, May i seek help for the formula I can use to make a list of activities from the given calendar setting? https://www.dropbox.com/s/tgzz9815ma95cdq/making%20list%20from%20calendar.jpg?dl=0

I have a spreadsheet with a table in it. At the bottom of the table is a field where the GST is calculated for entries in the table. The GST is 10% of the value. I had the following code in it that calculated the GST correctly: =ROUNDDOWN(SUM(npss_quote[Price ex. GST])*0.1,2) There are...

I have a downloaded report in Columns A through L and a listing of activities in columns P through Q. On the report, I am trying to match the descriptions in Column C with the listing of activities in Column P and then entering the account number in Column R to the appropriate cell in Column D>...

Is there anything wrong with the syntax of my for next loop? Sub cmdCopyr() Application.ScreenUpdating = False 'declare variables Dim TableLastRow As Long Dim LastRow As Long Dim TableNumberRows As Long Dim iCounter As Long 'counter of for..next loop Dim...

I have a spreadsheet and part of the code contains the following : Worksheets("home").Unprotect Password:="costings" If txtIncrease.Value = True Then If Worksheets("home").Range("E5").Value = "Activities" Then Worksheets("home").Range("X5").Value = "1"...

Hi, I am trying to create a calendar from a list of activities where if the cell is between a certain time frame it will output the name of the activity during that time frame. The name of cells are within three cells A5, B5 and C5 which the text will be combined into the one cell. However i...

How do I make it so I can see which activities should have been completed in a certain time frame (e.g 1 month). Which ones have been completed, and then which ones have over ran, so have not met their deadline. And can these also be counted up at the end? So a total of completed and not...

Hello all… Formula below returns zeros. Is there a better formula to get the proper activities count? A16/B16 are the beginning and end date cells. =COUNTIFS('Activity'!I:I,”>=”&A16,'Activity'!I:I,”<=”&B16) Thanks in advance, Moray

Morning everyone, I have a test for you all. I have a schedule of activities that people take part in every day. It is broken up into half an hour slots. e.g. 08:00 - 0830 people do 1,2,3,4 1,2,3 & 4 being 4 different activities, which equates to 7.5 minutes per activity. I'm looking...

Hi Im trying to get a spreadsheet to return the cumber of "Completed" activities which have been identified as Completed in column Q and where the date in column P on those activities occur between the dates shown in cells J2 & L2 I Tried with the formula below but its returning 0 When it...