Macro- Report Generation

[slraik]

I have another macro requirement.... to this
From the same path

I have two generate two additional reports.

1. Greater than 15 value report
2. Non green report

Requirement:

1. The macro should browse all workbooks at the path "C:\Test"
2. Access the risks worksheet from all workbooks
3. Copy all the risks whose status is open as per the column "I" of the worksheet for which the impact is greater than the numerical value 15 (This value is present at column D of the risks worksheet).
4. Before doing this copy the macro has to check the current week Rag status of each project which is at column E2 of the workbook under the "Progress Report" worksheet.
if the RAG status is green but it has a risk impact >=15 then this open status risk with impact value greater than equal to 15 should be copied onto the report.

Can u help me on this also please

Regards,
Lakshmi

[arlu1201]

Please attach a sample file.

Also you shouldnt have named the thread similar to the other thread i solved with you. It can raise a question on whether its duplicate.

[slraik]

I have another macro requirement.... to this
From the same path

I have two generate two additional reports.

1. Greater than 15 report
2. Non green status report

Requirement:

1. The macro should browse all workbooks at the path "C:\Test"
2. Access the risks worksheet from all workbooks
3. Copy all the risks whose status is open as per the column "I" of the worksheet for which the impact is greater than the numerical value 15 (This value is present at column D of the risks worksheet).
4. Before doing this copy the macro has to check the current week Rag status of each project which is at column E2 of the workbook under the "Progress Report" worksheet.
if the RAG status is green but it has a risk impact >=15 then this open status risk with impact value greater than equal to 15 should be copied onto the report.

Can u help me on this also please

Non Green Status Projects Px Wkx
Projects having Non Green status with No risk/issue maked as severe/major/critical
Project ID Project Name Project Manager Programme Manager Current Week Status


Green Status Projects Px Wkx
Projects with Green status and having severe risk or major/critical issue
Project ID Project Name Project Manager Programme Manager Current Week Status

The first non green status proejcts (Red/ Amber )should capture project details with no open risk value> 15
The second sheet green status projects should capture project details with open risks for which risk value is greater than or equal to 15.

Regards,
Lakshmi

[slraik]

Template could not be attached \

[arlu1201]

Is the file too huge? What kind of file were you attaching?

[slraik]

Template attached.