Auto filter data based off

Hi

I would like a macro to sort the data iin the data tab to how it appears in the test tab

I need the amounts for each person summed, and need the % and days averaged however I only need the people who have "A" in column G

Any ideas would be great

Thanks


filter test.xlsx

Dear rongil20!

I've attached a file. I hope this is a good solution for you.

Regards
Pan314

----------------------------------------------------------------------------------------------------------------------
Please show appreciation for all those that have helped you.
It will make you less fatigue than them free to deal with your request.
You can do this by clicking on the button * AddReputation, they can be found under every post.

Thanks

Wow, amazingly efficient and does the trick perfectly

Originally Posted by rongil20

Wow, amazingly efficient and does the trick perfectly

I am very happy and thank you for your praise!

In addition, please check out two things:

1) Read in my previous post the sentences below the signature. Do it if you agree.

2) When you reach what you want, declare the thread as SOLVED.