EducateExcel
New Member
- Joined
- Sep 15, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi There!
Hoping I can explain this well enough. In the attached sample file, I have product listed down column "C" to send to a store; then all of the stores listed "E:L". I want to have a macro in my personal book to read the active sheet and tell me by highlighting the cell red, if it's a duplicate value based on the value of column "C".
It would need to loop through each cell, that is not orange, and highlight he duplicate within the store. I am trying to quickly view what we are double sending to a location.
Thanks in advance!
Start:
Finish:
Hoping I can explain this well enough. In the attached sample file, I have product listed down column "C" to send to a store; then all of the stores listed "E:L". I want to have a macro in my personal book to read the active sheet and tell me by highlighting the cell red, if it's a duplicate value based on the value of column "C".
It would need to loop through each cell, that is not orange, and highlight he duplicate within the store. I am trying to quickly view what we are double sending to a location.
Thanks in advance!
Start:
| Highlight Planned Duplicates.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Region: | C | C | C | C | C | C | C | C | |||||
| 2 | Banner: | Divis. 1 | Divis. 1 | Divis. 1 | Divis. 1 | Divis. 2 | Divis. 3 | Divis. 3 | Divis. 3 | |||||
| 3 | Store Name: | City 1 - West | City 1 - East | City 1 - South | City 2 | City 1 - West | City 3 | City 4 | City 5 | |||||
| 4 | Display Group | Spot Name | Item Code | Class | 1A | 1B | 1C | 1D | 2E | 3F | 3G | 3H | ||
| 5 | FRONT DISPLAY | 18 | 18 | 18 | 18 | 17 | 15 | 15 | 15 | |||||
| 6 | FRONT DISPLAY | FRONT DISPLAY01 | ITEM1 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 7 | FRONT DISPLAY | FRONT DISPLAY02 | ITEM2 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 8 | FRONT DISPLAY | FRONT DISPLAY03 | ITEM3 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 9 | FRONT DISPLAY | FRONT DISPLAY04 | ITEM4 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 10 | FRONT DISPLAY | FRONT DISPLAY05 | ITEM5 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 11 | FRONT DISPLAY | FRONT DISPLAY06 | ITEM6 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 12 | FRONT DISPLAY | FRONT DISPLAY07 | ITEM7 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 13 | FRONT DISPLAY | FRONT DISPLAY08 | ITEM8 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 14 | FRONT DISPLAY | FRONT DISPLAY09 | ITEM9 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 15 | FRONT DISPLAY | FRONT DISPLAY10 | ITEM10 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 16 | FRONT DISPLAY | FRONT DISPLAY11 | ITEM11 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 17 | FRONT DISPLAY | FRONT DISPLAY12 | ITEM4 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 18 | FRONT DISPLAY | FRONT DISPLAY13 | ITEM13 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 19 | FRONT DISPLAY | FRONT DISPLAY14 | ITEM14 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 20 | FRONT DISPLAY | FRONT DISPLAY15 | ITEM15 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 21 | FRONT DISPLAY | FRONT DISPLAY16 | ITEM16 | PRODUCT | 1 | 1 | 1 | 1 | ||||||
| 22 | FRONT DISPLAY | FRONT DISPLAY17 | ITEM8 | PRODUCT | 1 | |||||||||
| 23 | FRONT DISPLAY | FRONT DISPLAY18 | ITEM18 | PRODUCT | 1 | 1 | 1 | 1 | 1 | |||||
| 24 | FRONT DISPLAY | FRONT DISPLAY19 | ITEM19 | PRODUCT | 1 | 1 | 1 | 1 | 1 | |||||
| 25 | SIDE DISPLAY | 18 | 18 | 18 | 18 | 17 | 15 | 15 | 15 | |||||
| 26 | SIDE DISPLAY | SIDE DISPLAY01 | ITEM19 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 27 | SIDE DISPLAY | SIDE DISPLAY02 | ITEM20 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 28 | SIDE DISPLAY | SIDE DISPLAY03 | ITEM21 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 29 | SIDE DISPLAY | SIDE DISPLAY04 | ITEM10 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 30 | SIDE DISPLAY | SIDE DISPLAY05 | ITEM23 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 31 | SIDE DISPLAY | SIDE DISPLAY06 | ITEM5 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 32 | SIDE DISPLAY | SIDE DISPLAY07 | ITEM25 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 33 | SIDE DISPLAY | SIDE DISPLAY08 | ITEM26 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
Starting | ||||||||||||||
Finish:
| Highlight Planned Duplicates.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Region: | C | C | C | C | C | C | C | C | |||||
| 2 | Banner: | Divis. 1 | Divis. 1 | Divis. 1 | Divis. 1 | Divis. 2 | Divis. 3 | Divis. 3 | Divis. 3 | |||||
| 3 | Store Name: | City 1 - West | City 1 - East | City 1 - South | City 2 | City 1 - West | City 3 | City 4 | City 5 | |||||
| 4 | Display Group | Spot Name | Item Code | Class | 1A | 1B | 1C | 1D | 2E | 3F | 3G | 3H | ||
| 5 | FRONT DISPLAY | 18 | 18 | 18 | 18 | 17 | 15 | 15 | 15 | |||||
| 6 | FRONT DISPLAY | FRONT DISPLAY01 | ITEM1 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 7 | FRONT DISPLAY | FRONT DISPLAY02 | ITEM2 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 8 | FRONT DISPLAY | FRONT DISPLAY03 | ITEM3 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 9 | FRONT DISPLAY | FRONT DISPLAY04 | ITEM4 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 10 | FRONT DISPLAY | FRONT DISPLAY05 | ITEM5 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| 11 | FRONT DISPLAY | FRONT DISPLAY06 | ITEM6 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 12 | FRONT DISPLAY | FRONT DISPLAY07 | ITEM7 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 13 | FRONT DISPLAY | FRONT DISPLAY08 | ITEM8 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 14 | FRONT DISPLAY | FRONT DISPLAY09 | ITEM9 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 15 | FRONT DISPLAY | FRONT DISPLAY10 | ITEM10 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 16 | FRONT DISPLAY | FRONT DISPLAY11 | ITEM11 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 17 | FRONT DISPLAY | FRONT DISPLAY12 | ITEM4 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| 18 | FRONT DISPLAY | FRONT DISPLAY13 | ITEM13 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 19 | FRONT DISPLAY | FRONT DISPLAY14 | ITEM14 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 20 | FRONT DISPLAY | FRONT DISPLAY15 | ITEM15 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 21 | FRONT DISPLAY | FRONT DISPLAY16 | ITEM16 | PRODUCT | 1 | 1 | 1 | 1 | ||||||
| 22 | FRONT DISPLAY | FRONT DISPLAY17 | ITEM8 | PRODUCT | 1 | |||||||||
| 23 | FRONT DISPLAY | FRONT DISPLAY18 | ITEM18 | PRODUCT | 1 | 1 | 1 | 1 | 1 | |||||
| 24 | FRONT DISPLAY | FRONT DISPLAY19 | ITEM19 | PRODUCT | 1 | 1 | 1 | 1 | ||||||
| 25 | SIDE DISPLAY | 18 | 18 | 18 | 18 | 17 | 15 | 15 | 15 | |||||
| 26 | SIDE DISPLAY | SIDE DISPLAY01 | ITEM19 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 27 | SIDE DISPLAY | SIDE DISPLAY02 | ITEM20 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 28 | SIDE DISPLAY | SIDE DISPLAY03 | ITEM21 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
| 29 | SIDE DISPLAY | SIDE DISPLAY04 | ITEM10 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 30 | SIDE DISPLAY | SIDE DISPLAY05 | ITEM23 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 31 | SIDE DISPLAY | SIDE DISPLAY06 | ITEM5 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 32 | SIDE DISPLAY | SIDE DISPLAY07 | ITEM25 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
| 33 | SIDE DISPLAY | SIDE DISPLAY08 | ITEM26 | PRODUCT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
Once Run | ||||||||||||||
