Format duplicate entries
in [Project]
|
From: KenCat on 6 Mar 2010 12:21 Hi, is there any one out there who is the proud owner of a vba script that can be run to identify duplicate entries in a column and format by colour ? If there is such a script I would be very grateful of a copy, as at present I am spending a lot of time exporting tasks to excel and using the conditional formatting tool. Thanks in advance if any one can help. Regards Ken.
From: Rob Schneider on 6 Mar 2010 12:36 I don't have such a macro; but achieve this I would simply sort the tasks and inspect for duplicates (which would be adjacent) to each other. Would work? --rms www.rmschneider.com On 06/03/10 17:21, KenCat wrote: > Hi, is there any one out there who is the proud owner of a vba script that > can be run to identify duplicate entries in a column and format by colour ? > If there is such a script I would be very grateful of a copy, as at present I > am spending a lot of time exporting tasks to excel and using the conditional > formatting tool. Thanks in advance if any one can help. > Regards > Ken.
From: KenCat on 7 Mar 2010 15:59 Thanks for replying Rob,this does seem like the only alternative to a fancy macro. Ken "Rob Schneider" wrote: > I don't have such a macro; but achieve this I would simply sort the > tasks and inspect for duplicates (which would be adjacent) to each > other. Would work? > > > --rms > > www.rmschneider.com > > > > > On 06/03/10 17:21, KenCat wrote: > > Hi, is there any one out there who is the proud owner of a vba script that > > can be run to identify duplicate entries in a column and format by colour ? > > If there is such a script I would be very grateful of a copy, as at present I > > am spending a lot of time exporting tasks to excel and using the conditional > > formatting tool. Thanks in advance if any one can help. > > Regards > > Ken. > . >
From: Rob Schneider on 8 Mar 2010 03:19 Perhaps. But a fancy macro from someone for free is probably unlikely but should it appear consider yourself lucky. Take note that when you do seek duplicates you should be careful about defining what "duplicate" means. Remember that tasks in Project are composed of a lot more information than just the task name. Two tasks which may hvae duplicate task names may have different durations, work, etc. to represent different elements of work--by definition they aren't duplicates then. --rms www.rmschneider.com On 07/03/10 20:59, KenCat wrote: > Thanks for replying Rob,this does seem like the only alternative to a fancy > macro. > Ken > > "Rob Schneider" wrote: > >> I don't have such a macro; but achieve this I would simply sort the >> tasks and inspect for duplicates (which would be adjacent) to each >> other. Would work? >> >> >> --rms >> >> www.rmschneider.com >> >> >> >> >> On 06/03/10 17:21, KenCat wrote: >>> Hi, is there any one out there who is the proud owner of a vba script that >>> can be run to identify duplicate entries in a column and format by colour ? >>> If there is such a script I would be very grateful of a copy, as at present I >>> am spending a lot of time exporting tasks to excel and using the conditional >>> formatting tool. Thanks in advance if any one can help. >>> Regards >>> Ken. >> . >>
From: Jan De Messemaeker on 8 Mar 2010 14:03
Hi, Did it once but as part of a much larger procedsure. It looks about like this: dim ColorJob as task Dim Job as task filterapply "All Tasks" Outlineshowalltasks select all for each colorjob in activeproject.tasks if not colorjob is nothing then for each job in activeproject.tasks if not job is nothing then if colorjob.name=job.name then selectrow row:=colorjob.id, rowrelative:=false application.fontex cellcolor:=pjyellow end if next job endif next colorjob Hope this helps -- Jan De Messemaeker Microsoft Project Most Valuable Professional +32 495 300 620 For availabliy check: http://users.online.be/prom-ade/Calendar.pdf "KenCat" <KenCat(a)discussions.microsoft.com> wrote in message news:123BE540-62EC-4A67-A0FC-F845A0C41FE2(a)microsoft.com... > Hi, is there any one out there who is the proud owner of a vba script that > can be run to identify duplicate entries in a column and format by colour > ? > If there is such a script I would be very grateful of a copy, as at > present I > am spending a lot of time exporting tasks to excel and using the > conditional > formatting tool. Thanks in advance if any one can help. > Regards > Ken. |