Format duplicate entries
in [Project]
|
From: KenCat on 8 Mar 2010 15:54 Cheers Rob and thaks for the advice. "Rob Schneider" wrote: > 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: KenCat on 8 Mar 2010 15:55
Thanks Jan, I will give it a go and inform you of the outcome. Ken "Jan De Messemaeker" wrote: > 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. > > . > |