Dear Ozgriders, this is my first post to this forum. I have been looking for some macros to help improving my project plan, but none of the examples I found did quite exactly what I was looking for.
As explained and illustrated in the enclosed spreadsheet, I am trying to build a project plan in Excel. My plan is becoming quite large (300 rows by 900+ columns) and heavy (>3MB). In order to keep track of the project plan (Gantt chart) and of the resources (people) I currently use "IF" formulas and conditional formatting. This works well for a small table, as shown in the enclosed example, but it becomes quite slow for a 300x900 matrix. Therefore I would like to streamline and speed-up this process by using macros.
Can you help me and show me macros that could do the trick?
I imagine some of you have already built similar project plans in Excel?
Thanks a lot in advance for sharing your knowledge!