Thanks Daniel for a great help but
i appriciate if you can able to give me the complete macro code for my file
so i have no need to modify any code
hope you understood it is easy for you to update the complete code rather
then me
thanks once again.
On Wed, Feb 23, 2011 at 10:29 PM, Daniel wrot
Here is an example to replace sheet Batch column K with a macro:
Sub test()
'sheet Batch column K
With Sheets("Batch")
For Each c In .Range(.[A7], .[A65536].End(xlUp))
.Cells(c.Row, 11) = Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" & c.Row
& ")*(DB!$AP$2:$AP$46803=""Yes""))")
Next c