Prev: Over-allication (best way to troubleshoot?)
Next: quicker more efficient formatting macro needed
From: Elvis on 11 Mar 2010 13:37
I have a decent size schedule (8k lines) that gets statused each week with
percent work complete status, actuals starts, actual finishes and new ECD for
start and finish. Toss in the fact most items are networked and may need to
be modified for 'work arounds' this meeting is very time consuming and a
large portion is spent watching me make the entries.

to cut down on time I have created my own 'que sheet' for holding the
updates submitted from the team. Instead of having them read off the updates
they've made to a copy of theschedule, they just send it to me. I copy the
project fields they will be editing and then pasted them into a View created
with Dur1, start1, fin1, start2, fin2, start3, fin3 and a number field to
hold the percent complete. I then run a macro to compare the deltas from
their data to what I have in the standard project fields and highlight those
changes. we just walk through and review the changes and afterwards when
they are all agreed to, I on my one go through and make the changes.

trouble is: I have to access each cell currently in my code to change the
format and that takes serious time. In excel I can do that WITHOUT accessing
a particular field but do not know how to assign the format in Project. any
help speeding this up is appreciated.

I'll post the code in another string

Thanks so much for any ideas.

 | 
Pages: 1
Prev: Over-allication (best way to troubleshoot?)
Next: quicker more efficient formatting macro needed