BullseyeThor
Board Regular
- Joined
- Dec 23, 2010
- Messages
- 84
- Office Version
- 365
Hi All
I have a work sheet which is used by 4 departments and has data inputted by all of these.
However when one department pastes in their information they have highlighted rows to indicated certain things. I need the highlighted cells to carry accross to any duplicate entries accross the whole workbook.
Example.
854521 Bread 5 loafs
Lets say that is highlighted yellow on the main sheet with all items but then the workbook is broken down into suppliers. I need the same thing on the supplier tab to highlight as well so that no one has to search 1000's of lists.
Can anyone help? Prefer code as formulas can be unrealiable at times.
Thanks All
I have a work sheet which is used by 4 departments and has data inputted by all of these.
However when one department pastes in their information they have highlighted rows to indicated certain things. I need the highlighted cells to carry accross to any duplicate entries accross the whole workbook.
Example.
854521 Bread 5 loafs
Lets say that is highlighted yellow on the main sheet with all items but then the workbook is broken down into suppliers. I need the same thing on the supplier tab to highlight as well so that no one has to search 1000's of lists.
Can anyone help? Prefer code as formulas can be unrealiable at times.
Thanks All
