Need help on macro function for the adding selected cells

Dear All,
I have attached an excel sheet below named MacroEx.xlsm
Which has two Sheets Sheet1 and Sheet2
What my requirement is, in Sheet2, I need to calculate the sum of a particular Job_Id's (Eg:1001) Amounts where Type should be "A" and put that sum results into Sheet1's "Total Amount of Type A" column of corresponding Job_Id and so on for Type "B" as well

Kindly open the excel sheet to be more clear and assist me on accomplish this

Thanks all

For D4

Please Login or Register  to view this content.

For E4

Please Login or Register  to view this content.

and copy down

Kind regards
Leo

Great... it works
Thank you Leo and really appreciated