Hi... My excel have multiple sheets as below:
- Sheet1(Master Data) ... No, Name, Div, Dept, Status
I need to write a VBA code that will COPY an entire row automatically into a respective sheet if the value in the "Status" cell meet the criteria "High", "Medium" or "Low".
Whenever changes was made in the Master Data, it is also reflect to the respective sheets automatically.
Hope someone can help and thanks in advanced.