PDA

View Full Version : Need Help: Macro that can filter data and plot results on a matrix



Beentrill
10-05-2014, 10:04 AM
Hi,

I`m working on this project and I`m really stuck.

Here is the entire scope of the project, just so you can better understand what I need.

I have an employee data table. I need to build a macro that can:

1. Filter the data using 11 criteria - has been built(still buggy)
2. Display the Employee`s First Name, Last Name and Employee ID on the `TPT`Matrix based on their BoxRating on Worksheet(`SampleData`), Column V.
3. The Matrix will need to dynamically expand to handle the filtered returns
4. Display the Employee information and allow editing to certain fields

Here`s where I`m stuck:

After filtering the data, I`m still trying to figure out how to plot the Name and ID on the matrix. They need to be positioned based on their Box Rating Score(!FilterReturn, Column V)

So, the TPT Matrix has to be able to handle a growing number of names. I was thinking about creating a `boxes`that have 2 columns and 10 rows. But based on the maximum number of any box rating, it would dynamically add rows to that table.

If anyone has any suggestions, I would love to hear them.

Thanks