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...

Sub and Function Names Sub MachineGun () Sub Stitute () Sub Marine () Sub Human () Function Ality ()

Good Morning All, Thanks for the feedback. I have had to accept defeat and put all years data on one worksheet for the information to be populated into the summary report, due to sumproduct not allowing the 3D referencing.

Good Afternoon I have a worksheet which contains telephony information At present I have three tabs and then a summary tab. One tab for 2011, one for 2012 and one for 2013 I have a formula for each year which the team leaders can enter a start and end date and get the telephony information...

@DaveTurton Thank you so much, I have been stressing over this for the past 4 days!! It works perfectly.