copying data from one sheet to another if value in another cell changes

do you want it to move as soon as a 1 is choosen, or would you like to enter a bunch of 1's and then move them all over with the push of a button?

k, think this is what you want. this will immediately move the file off the "Production" sheet and onto the "numbers" sheet when you make a selection of 1 in the B column (after you finish the entry). to test it enter ones and watch them dissapear.

If you just wanted to copy them and leave them on both sheets, then you probably just need a pivot table to view the tested files...i would think.


btw..the code to do this is a worksheet event (placed in the Production sheet code module):

Please Login or Register  to view this content.

Also, to get your sum formula to work when i was deleting rows...(broke your formula)... i reauthored that formula to be =SUM(INDEX(myTable,,2))

myTable is a named formula (you can view in the name manager) which is defined as: =Production!$A$2:INDEX(Production!$2:$1048576,COUNTA(Production!$A$2:$A$1048576),2)

Ok, the new attachment here demo's a pivot table solution. It will auto-update when you select the numbers sheet and will show you the file numbers with a 1 in the "tested" column