Hello All,

I have a workbook which contains several worksheets - one of which is a master sheet. The subsequent sheets are all portions of the master sheet divided up (by vendor). The spreadsheet deals with material that is on order, and the rows are color coded depending on whether the material will be on time, late, etc. Is there a way to propogate the changes made to the master sheet to the same information in the vendor-specific sheet, and vice versa? For example, if I change the master sheet row from orange to green, I would like this to propagate that color change to the matching row on the vendor-specific sheet and if I change the vendor-specific sheet's row color, I would like this to update on the master for that information.

In case it matters:

The master worksheet is broken down into 8 columns: vendor | part # | vendor part # | PO# | quantity | notes 1 | notes 2 | notes 3 |

The vendor-specific sheets include all of the above, except for the vendor part # column (7 columns total).


Thank you!

-Krussadams