Search results for query: *

Thanks Skipvought, will bookmark that one!

Many thanks - that's exactly what I wanted!

Hi I have a sheet which calculates a value between 0-29 based on other cells in the sheet. What I want to do is have a condition returned dependent upon the number range, for example, 0-5 returns the word "green", 6-8 returns "amber" and 9-27 returns "red". I can do this over three...

Sub MailBCST() ' ' MailBCST Macro ' Macro recorded 11/28/2008 by User ' ActiveDocument.SendMail End Sub This is all I have - sorry, I really don't understand VBA...

Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...

Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...

Many thanks Kyle

EDIT - I have now got the scores I need by using the IF command, if there is no score I get a FALSE message (which is fine), how do I add the scores that I do have, doing a SUM always returns a nil value - is this because there is text in there as well?

Hi all I am also trying to write a questionnaire. Ideally people will put an X in one cell to indicate their preference. Each answer will then have a score. How do I SUM on the condition that one cell has an X in it and the adjacent cell has the relevant number, is it something like COUNTIF and...

Many thanks for help. I don't understand how to use the IF command with AND which I presume I need to since I am asking it to look at two values before producing a third, which I am also unsure of. The bold is for a bill I am separating out so I delete the bold lines to leave the amount...

Hi Newbie here so I hope I have the right board... Two questions... Trying to write a formula which captures risk and liklihood. What I am after is a cell to display a text value depending on whether the previous two cells contain Low, Medium or High text values. So H/H would return one...

Hi JBlack Thanks for this, I am using 2003. To be honest I am using Project more as a task list. As said, I can do the other bit I describe but would like to offer my manager the other option and let him pick which one he would like? Thanks in advance. Kyle

Hi all Newbie here. I am trying to show % complete values as graphical RAGG indicators - please could someone help? I have managed to work out how to put the circles in and also how to lift the percentage complete value - I just can't seem to apply conditions to the figure after that, i.e...