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...
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...
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...
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...
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...
Thank you so much - this has worked!!
It was due to me having A35:A124 rather than A95:A124, and I did a find replace to change the numbers, must have missed this one.
thanks again Narayan
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...
Hi all,
I'm Carley, working as an MI Analyst in Brentwood Essex.
Loving this site for helping me with quick fixes and to assist with queries.
Great job and Thanks to all involved :)
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...