Search results for query: *

i have a formula for a custom task field: IIf([Number2]=4,IIf([Finish]<now()-14,"Yes","No"),"No") is there a way to manipulate the above formula to also check whether it's a summary task? thanks -hisbad

sorry for the ambiguity... version 2003 standard. I populated the resource sheet using the wizard that grabs the names from Outlook. So when I am in the Gantt cgart view I use the Resource Names column to add a resource to a task. I would also like to have "Text1" (in the task row) to pull...

I am using the Resource field that is populated from the Resource sheet. However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well. It's not available in the Import Values option It's not available as the formula I can't...

The only problem with IsItTheRightFormula = "Stop Cheating You Little Toads" is.. if they try to get it right, i mean they really really try, and they get it wrong, you're still caling them a cheat. -hisbad

when you have the Define Name box open, at the bottom there is a 'Refers to' field. in that field you should type "=GET.CELL(48,INDIRECT("rc",FALSE))" exactly as ive written it. let me know how you get on.

this gives you a clear visible indicator. any cell that is a formula as apposed to a number will be highlighted by whatever format you put in the conditional formatting. i'm unsure of whatelse you want.

In MS Project... I am using the Resource field that is populated from the Resource sheet. However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well. It's not available in the Import Values option It's not available as the...

go to Intert/Name/Define in the Names in workbook box type "isAformula" in the Rferes to box type "=GET.CELL(48,INDIRECT("rc",FALSE))" then just set the condition formatting for the cells you want to check as Formula is "=isAformula

i figured it out - can't be done withut VBA (well I couldn't do it without vba!) Private Sub Project_Change(ByVal pj As Project) Dim ts As Tasks Set ts = ActiveProject.Tasks For Each t In ts If Not t Is Nothing Then If Not t.Summary Then t.Text11 = t.Name & " (" &...

In MS Project is there a way of identifying a task's Summary Name? For example, I want the Text1 field to be [Name.Summary] & [Name] any ideas?

Ken Your answer looks a lot neater than mine even though (I think) they give the same result. Do they have an underlying difference? IOW, When would you use one ond not the other? Thanks HisBad

=ISBLANK(Sheet1!A1)

include: & chr(32) &

have a look at Ken's post in this thread. excel special characters

the code works when i use it. i suggest you take geoff's advice and repost in the vba forum, ask why you can't get that code to run. thanks hisbad

ActiveWorkbook.SaveAs Filename:="C:\Auto Invoices\Invoices " & MonthName(Month(Date)) & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False

i retried with my own advice and the change macro failed to run. i had to do the following to make it work. close excel. reopen with just the workbook you're working on. do as i said before but this time copy and paste this code. Private Sub Worksheet_Change(ByVal Target As Range) For x...

right click on your worksheet tab and choose "View Code" type this code Private Sub Worksheet_Change(ByVal Target As Range) Cells.Replace What:="&", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False Cells.Replace What:="/", Replacement:="", LookAt:=xlPart...

Enter this formula where you want the answer: =SUMIF(B5:B12,"RM",C5:C12)

i have a macro that (while performing its task) counts down from 100 to zero. how do i make count up so it looks like a percentage. here's the one line of code that i need to change. Application.StatusBar = (100 / (n - myRow) * (i - myRow))