Recent content by Carley

Good Afternoon, I am trying to create conditional formatting on a training log and I am running into some difficulties. I am using excel 2010 I am unable to upload so I will try and explain as much as possible. On Sheet 2 - I have a list of 5 different training types. - Lets say these for...

Thank you so much, I kept getting the bracket in the wrong place and #value! kept appearing!!

Good Morning. I was wondering if there was a way to combine an if and a network days formula. I have a start date and a completed date, and I want the formula to bring back the amount of network days it has taken to complete the work. (which is easy) But I want the cell to show a 1 if the...

Hi Sam, Yes, the managers have both personal folders in outlook called Policies Cancelled But then they have a mailbox call Operational MI I want a macro that when they click on a button in excel, it will take them to either the personalised folder (Policies Cancelled) or the alternate...

Good Morning, Is there a code which will go to a particular folder or Mailbox name within MS Outlook? I have found the following code which opens MS Outlook, Private Sub Mail_Click() Shell ("OUTLOOK") End Sub but then some of my team managers have other mailboxes for the team, and...

I needed a password eight characters long so I picked Snow White and the Seven Dwarves

Hi Bob, As it is an individual report, putting as a shared document is not really an option.

Good Afternoon all from a thankfully sunny UK! I am in the process of building individual productivity spreadsheets for agents and some of the feedback I have recieved is that the current spreadsheet they have, they do not like it password protected. The managers do however want an audit...

Thank you @SirJB7 that works! I was going round in circles! Out of interest, is there anything I can to to get the cell / Sheet to re-lock once the time is entered into the cell by the user?

Not sure if this will help, but when I have had similar problems I have added on a +0) to the end of the formula and then it works =SUMPRODUCT((($L$5:$DS$5=D$1434)*($I$7:$I$500=$B1441),$L$7:$DS$500)+0)

Little background - I am in the process of creating a productivity spreadsheet, so when a resource chooses a certain activity the times are automattically populated from pre-agreed timings spreadsheet. However, there are some activities that the resource will need to add the times themselves...