Search results for query: *

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

Hi Julie ,Thanks for your reply.In my project file I went File->Open, selectrd my excel file,the import wizard popped and I hit "new map" and then "append the data to active project", next selectrd all options "Tasks,Res...." ,then I had my source worksheet name chosen, then as soon I type the...

Hi all, thanks for your feedback.@julie ,I had my unique identifier set for the excel file, and also tried to import from excel to project.Also my project had the same unique id.Did not work.I needed to do some lookup before I import that is the problem. @skipVought ,My programmimg skill is okay...

I had my unique identifier set for the excel file, and also tried to import from excel to project.Did not work also

Hi Julie, Thanks for your reply.I am trying to move my all project information and schedules from excel to microsoft project.I have around 600 to 650 projects.But I need only 400 project information to move from excel.I already have my project file open with those 400 files , now I need to get...

Hi there,I was wondering if there is any way I could compare fields between excel and microsoft project and import values that matches the comparison.suppose I have two columns in excel named "Sky" and "River". I also have two fields in microsoft project named "sky" and "River". In my project...