Forum Discussion
Update Daily progress from excel into MS project
Dear All, I am new to MS project and would you kindly help me please with my question: There is task (actually lots of tasks, but for simplicity i will consider 1 task) that started at some tim...
Antares,
Robhprojility gave a good rundown on what is available in Project to view the data. However, your question asks how to get existing progress data from Excel to Project, so let me address that.
You can of course manually copy each day's data from Excel to the timescale grid on either the Task Usage or Resource Usage view but that process is tedious and can be prone to entry error.
If you don't need input logged on a daily basis in Project and can live with a cumulative update, then you can set up an import map to automatically update data from Excel to Project.
However, if you need/want to track daily data from Excel to Project, then the best option is with a VBA macro.
Hope this helps.
John