Hi All,
Am trying to do automation for share of shelf planogram working in excel, the below table I displayed the name based on block count in column "G" using if condition. It might be vary if the count is changed. Now I want to display the same picture in each cell based on the cell value. "The actual name is more than 25 and cell is 120"
It will be more helpful if get the solution for this.
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;">
<col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;" span="5">
<col width="64" style="width: 48pt;">
<col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;">
<col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<tbody>
</tbody>
Thanks,
Am trying to do automation for share of shelf planogram working in excel, the below table I displayed the name based on block count in column "G" using if condition. It might be vary if the count is changed. Now I want to display the same picture in each cell based on the cell value. "The actual name is more than 25 and cell is 120"
It will be more helpful if get the solution for this.
A | B | C | D | E | F | G | H | I | ||
1 | BLCOK1 | BLOCK2 | BLOCK3 | BLOCK4 | BLOCK5 | Block Count | NAME | PICTURE | ||
2 | Top Shelf | COLGATE | COLGATE | SIGNAL | ORALB | PEPSODENT | 8 | COLGATE | Bitmap | |
3 | Shelf-2 | COLGATE | COLGATE | SIGNAL | ORALB | PEPSODENT | 4 | SIGNAL | Bitmap | |
4 | Shelf-3 | COLGATE | COLGATE | SIGNAL | ORALB | PEPSODENT | 4 | ORALB | Bitmap | |
5 | Bottom Shelf | COLGATE | COLGATE | SIGNAL | ORALB | PEPSODENT | 4 | PEPSODENT | Bitmap |
Thanks,