Macro to find the sum of shares against each name

Hi Team,

Need help to create macro for the manual activity that i does.

I have data like attached where each resource holds share in many projects. I need resources who have sum of shares as more than 100 (sum of share across all projects) to be in one sheet and resources with sum of shares less than 100 (sum of share across all projects) to be in another sheet. Resources with sum of shares as exactly 100 should be ignored.

The ID is unique for each resource. So i usually creates a pivot with ID and sum of shares, then copy paste the “above 100 shares” and “less than 100 shares” to the respective sheets.

I have did the same manual activity for the attached sample and pasted the “above 100 shares” and “less than 100 shares” in the respective sheets.
Please help me with codes to automate this.