Changing the code

[hakunamatata]

Hello Everybody
I want to update the code according to the new requirements. The code and new requirements are attached with the workbook. Its hard to explain without example so thats why examples are shown in the workbook.

[Bob Phillips]

Use this formula

=IF($B4<>"",SUMIF(Sheet4!$B:$B,Sheet6!$B4,Sheet4!D:D),SUMIF(Sheet5!$A:$A,Sheet6!$A4,Sh eet5!C:C))

[hakunamatata]

Thanks for your reply.
Isn't it possible to change the existing code which is written in macro.

[Bob Phillips]

Why, when a formula suffices?