tjtsantos
10-31-2008, 12:46 AM
Hello Experts,
I may need some help again.
I have a sample excel file attached. I am trying to output a summarized table like in the "Summary" tab. The data came from the "Data" tab. The drop-down list I used can be found at the "Category" tab.
In the "Summary" tab, what I am trying to output is the list of Level matching the category I selected.
If this can be done using Pivotable it will be of great help. However, I am not that too familiar with using the Pivotable.
Thank you in advance.
Tony
I may need some help again.
I have a sample excel file attached. I am trying to output a summarized table like in the "Summary" tab. The data came from the "Data" tab. The drop-down list I used can be found at the "Category" tab.
In the "Summary" tab, what I am trying to output is the list of Level matching the category I selected.
If this can be done using Pivotable it will be of great help. However, I am not that too familiar with using the Pivotable.
Thank you in advance.
Tony