As shown in attached file, we are monitoring the stock of different type of materials, If the stock level falls below a certain limit then the color of cells of column "F" becomes "Yellow" further fall of stock level converts the color of cell to "Pink". There may be 15 to 20 sheets in this file.
We can monitor the stock level by analyzing each sheet separately.
Now we want that - If the color of cell of column "F" is "Yellow or Pink" then the entire row should be copied & pasted in Summary sheet. The format of Summary sheet is given in attached file.
Please suggest the macro codes to solve the purpose,
Thanks in advance.