insert column BALANCE after collection data across multiple sheets

[KalilMe]

hi
I have many data across multiple sheets . what I want match data COL B,C, D across multiple sheets and summing the repeated data and insert the COL BALANCE
COL RET, SALE repeat for many items should sum the values . the COL BALANS should subtract between COL RET,SALE . some times I create new sheets with same structure . so a macro should be dynamic . I put the result in sheet collection . it should create whole data with headers

[nankw83]

Hi KalilMe,

Try below code ...

Please Login or Register  to view this content.

[KalilMe]

wow ! it's fantastic . may you make the formula as value in col G ? . it shouldn't show the formula and any empty cell should show hyphen "-' instead of zero
thanks again

[nankw83]

Add 2 more lines in red ...

Please Login or Register  to view this content.

[KalilMe]

well done ! thanks so much for your solution

[nankw83]

Glad to help