update from one sheet to another

[goldglare]

Hi I encountered this problem yesterday...

I have a Passed column which is a combobox field in all the 4 excel sheets in a document. I also have a Cycle Control Sheet which summarizes all the tests passed like percentage passed, number of tests passed, number of bugs found etc. When i update the passed column for a particular row in one of the sheets it should automatically update in my cycle control sheet whether the test is passed or it is a bug found. Please help me with the code...

 

[SteveO59L]

Is the "passed" column the same column in each sheet ?

 

[goldglare]

yaa the passed column is the same column in each sheet...