Recent content by tonew

Hello there, I have a project file where I have projects with set up as "schedule from project finish date" and "fixed work" and "must finish on" constraint. now I did some importing information to manually edit. Then when I am done and then I switched from manual to auto.Then My project...

Hi Julie, thanks a lot.I rally appreciate your help.I will post my question there then.Thanks!

You are right I could use a flag.I really like that idea!I am not using excel anymore,I already imported from excel and now all calculation I am diong is in Project file. It could be nice if I could run the code to write number1 in my Work field.I just dont know how I do it.Even if I need to run...

Thank you so much for asking!In my project file I have a column named "estimated complition"(I used Date1 field for this) which I imported from excel.Now I have another column "Finish" field.Now I am asked that the "Finish" field will default to the Date1.But if someone wants can enter other...

Yah you are right.There is no way.My boss was asking if I could use VBA to customize those Work or Cost fields.I dont know if I could.Could I?Ahh this project is killing me.Thanks a lot for your help dear.

Hi there, I have one field "Work".where, Work=Number1*100. I wanted to use a formula in the work field but but I could edit as when I go custom field option in "Work" field ,I do not see any option for formula.I could use formula for text1..text20 or date1....Date20.But could not do for Work or...

Hi Julie thank you so much for your help.It worked perfect.Yes mine is autoschedule task.Thanks a lot.

Thanks Jilie.I was looking at microsoft project website "http://office.microsoft.com/en-ca/project-help/set-a-start-date-or-finish-date-constraint-for-a-task-HA010113073.aspx#BM5" where I found the following statements.At one point it said for all task do the following.Could you please tell me...

Hi there, Could anyone please tell me if I could set a constraint type "must finish on " fixed for a column.For example if I have two projects one finish on July 10,2014 and other finish on december 12,2012,then if I change start date or duration then the finish date does not change for these...

Hi Guys,Thanks a lot for your help.I was able to import with lookup from Excel to MSP.Really appreciate your help!

Oh Sorry I got the question wrong, yes there is a dropdown box to choose the sheet name, by default it had the right sheet name chosen.But I could change from the list.sorry about that.

Yah, just double checked couple of times,no space at all.Thanks.

@SkipVought ,no there is no space in there,that is just a typo when I was typing here.Sorry for the confusion.Thanks.

@SkipVought ,the field name is " Name " in excel,and in projectMy field name is "Name" and field title id "Name" too.Thanks.

@SkipVought, Thanks so much for your reply.Links were really helpful.I will have to go through the code here.Hopefully I will get it.Thanks