VB script to filter and update value in different sheet

[silverblade]

Hi Folks,

I'm new to VB and need guidance with my task in excel.

*I have an excel workbook with multiple sheet (max 6 sheets).

*I need to filter values (pass/fail/in progress)in Sheet 3 ("O" column) which has the name as "Latency" and update the "pass" count in Sheet 1 in a specific row (lets say AE4) and respectively for other filter values.e same code to

Once this is done I can modify the same code to other palces in my worksheet.

[silverblade]

any help?

[silverblade]

I have added an example of what i want to do:

Please refer the attached excel.

For example:

In WBR 50 sheet:

The count for "#of submissions processed" for week 50 is derived from "Latency Week 50" sheet by selecting the "Pass" and "Fail" filter".

The count is 79, which should be automatically be updated to "AK3".

If this is done I'll follow the same logic to all the rows.