Search results

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

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

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

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

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

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

Good Morning I have created a stand alone dashboard for my team leaders which automattically opens for them in the mornings and has links to all the files they need to use on a daily basis. (in case you are interested to code I used for the auto opening is: Sub Auto_Open() ' ' Auto_Open...

Hello Hoping that someone can assist, I have a formula which I want to bring back the oldest outstanding record for the current month. I have a worksheet named Outstanding which has three columns Column A has date range showing One for outstanding not refered (Column B) One for refered...

Hoping that someone can assist me, I need to open a new windows explorer with a path that contains an equals symbol. Code I have is x = Shell("explorer /n,/e,group.netglobalCroydonBroker2013= Broker Complaints", 1) when I put this in my personal folders open instead. If I take out the...