Automate the creation of a entry in another sheet depending on a status of a cell in the source.


I have a grid that contains products which may or maynot need to be shipped to another region, I need to be able to list the products that require shipping and be able to view the status and update as needed.

Example below, shows the region the product is for, the date required to ge on site, flag if it is suppose to be shipped and the product name.

I have created a grid that has the product name (designation), shipping status, date needed, date shipped, shipped to,

The product name, date needed and shipped to would pull from the source, the other entries would be updated manually or some form of automation or conditional formatting.

How would I have the three entries auto populate the ship grid or another way of doing it?