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>