Format duplicate entries

[KenCat]

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.

 

[Rob Schneider]

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

 

[KenCat]

Thanks for replying Rob,this does seem like the only alternative to a fancy
macro.
Ken

 

[Rob Schneider]

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

 

[Jan De Messemaeker]

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]

Cheers Rob and thaks for the advice.

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





.

 

[KenCat]

Thanks Jan, I will give it a go and inform you of the outcome.
Ken