copy names and values of columns from multiple sheets to one sheet and subtract

hello
i would copy values of columns b,c from two sheets(total,out) to sheet(list) from range b: c and subtract between c,d and the result in col e i put expected result in sheet (list)
thanks

You have extra space in "List " sheet name.

Please Login or Register  to view this content.

brilliant ! jindon this is what i want but i ask about do that automatically without button do that by worksheet change event i no know if i get in into change event this code or the code totally change ,any advice, please?

You can call it from Worksheet_Activate Event, so that it updates every time you select back "List " sheet from other sheet.
I have changed the sub procedure name from "test" to "UpdateMe".
To "List " sheet code module.

Please Login or Register  to view this content.

To a Standard code module

Please Login or Register  to view this content.

great work !jindon & daves the codes work excellently many thanks guys