Hi,
I am trying to make a monthly performance progress table.
Attached is a sample.
Basically, I have created 2 tabs - one for task, the other for raw data (or call it progress record)
In Data tab, when i enter date and select 'Task' during drop down list, I want to bring the related target value that is set in the Target tab in relation to Month (or date).
We have two types of target - qty and completion date
Later, I am going to make a pivot table so that I will make a monthly summary in graph or progress chart as per task.
Thank you for your help in advance.
MK
Bookmarks