I have a excel sheet full of data. I need a macro that looks for where the RAG is Amber or Red and brings the information onto a separate tab.
The below table shows the source data this is on a tab called POAP DD-MM-YY (This date and tab will change every week)
I then want the Macro to format the above data onto a new tab where the RAG says Amber or Red and looks like this
Thanks
The below table shows the source data this is on a tab called POAP DD-MM-YY (This date and tab will change every week)
CHANGE TYPE | ACTIVITY NAME | BUSINESS OWNER | TRANSITION TEAM OWNER | CRITICAL DEPENDENCIES/CONFLICTS | START DATE | PLANNED PROJECT HOURS | EXPECTED COMPLETION DATE | WEEKLY STATUS/UPDATE/ COMMENTS | WEEKLY RAG |
data1 | data1 | data1 | data1 | data1 | data1 | data1 | data1 | data1 | Amber |
data2 | data2 | data2 | data2 | data2 | data2 | data2 | data2 | data2 | Green |
data3 | data3 | data3 | data3 | data3 | data3 | data3 | data3 | data3 | Red |
I then want the Macro to format the above data onto a new tab where the RAG says Amber or Red and looks like this
WEEKLY RAG | ACTIVITY NAME | BUSINESS OWNER | TRANSITION TEAM OWNER | WEEKLY STATUS/UPDATE/ COMMENTS |
Amber | data1 | data1 | data1 | data1 |
Red | data3 | data3 | data3 | data3 |
Thanks