Hi,
I have very large file for 'Production Planning' in my work. the spreadsheet contain 15 mixers and every day we have 3 shifts. I want to make condition when the market is different (we have 4 different markets). when I tried to do it for each cell the file was very slow and stuck all the time. I also tried to make a named range but it also will be very large (15mixers X 3shifts X 365days= 16,425 named range). the conditions are different colors for all the details considering the market. Do have any idea how to do it ? Thank you, Oz
for example:
<tbody>
</tbody>
I have very large file for 'Production Planning' in my work. the spreadsheet contain 15 mixers and every day we have 3 shifts. I want to make condition when the market is different (we have 4 different markets). when I tried to do it for each cell the file was very slow and stuck all the time. I also tried to make a named range but it also will be very large (15mixers X 3shifts X 365days= 16,425 named range). the conditions are different colors for all the details considering the market. Do have any idea how to do it ? Thank you, Oz
for example:
| Mixer B | Mixer A | Details | Shift | |
| Color 2 | Color 1 | Material No. | 1 | Day 1 |
| Color 2 | Color 1 | Material Name | ||
| Color 2 | Color 1 | Batch No. | ||
| Color 2 | Color 1 | Order No. | ||
| Color 2 | Color 1 | Comments | ||
| Color 2 | Color 1 | Quatity | ||
| Market B (Color 2) | Market A (Color 1) | Market | ||
| Material No. | 2 | |||
| Material Name | ||||
| Batch No. | ||||
| Order No. | ||||
| Comments | ||||
| Quatity | ||||
| Market | ||||
| . | 3 | |||
| . |
<tbody>
</tbody>
