exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
On Column B I have list of different types of descriptions and on column C , D & E I wanted few details from column B (descriptions) as per below example. So where ever the description starts with intelnumr I need a VBA code to pick below details as per below example. For the ones which does not start intelnumbr it should be blank on column C, D & E.
And on column C, D & E if it is already updated with any value VBA code should skip that line and fill only for blank cells on column C,D & E.
<tbody>
</tbody>
Below are few lines which I have.
When the VBA is executed check for intelnumr on descriptions and update required value on column C,D& E if these columns already have a value inputted it should ignore and go to next line. And this data will increase everyday
<tbody>
</tbody>
And on column C, D & E if it is already updated with any value VBA code should skip that line and fill only for blank cells on column C,D & E.
Column B | Column C | Column D | Column E |
intelnumr ID G32164317 - N TILDA RICE 2.652 SV 0.65 - 052289169 - TILDA BASMATIwir - 201652 | G32164317 | 52289169 | 201652 |
<tbody>
</tbody>
Below are few lines which I have.
When the VBA is executed check for intelnumr on descriptions and update required value on column C,D& E if these columns already have a value inputted it should ignore and go to next line. And this data will increase everyday
Column A | Column B | Column C | Column D | Column E |
1234 | intelnumr ID G32164317 - N TILDA RICE 2.652 SV 0.65 - 052289169 - TILDA BASMATIwir - 201652 | G32164317 | 52289169 | 201652 |
1235 | intelnumr ID G32254314 - N1 TILDA RICE 2.652 SV 0.65 - 051098169 - TILDA BASMATI BROWN RICE 500G - 201652 | G32254314 | 51098169 | 201652 |
1236 | intelnumr ID G32156396 - N1 TILDA RICE 1.391 SV 0.39 - 081475253 - TILDA PULSES EDAMAME 140G - 201652 | | | |
1237 | D# 123348123 Coffee - P17 Gate Fee - Euro Food Brands: TPNB - 53847432 : S Ref GRO_22420_47323 : N | | | |
1238 | D# 123348123 Coffee - P17 Gate Fee - Euro Food Brands: TPNB - 53847432 : S Ref GRO_22420_47323 : N | | | |
1239 | D# 123348123 Coffee - P17 Gate Fee - Euro Food Brands: TPNB - 53847432 : S Ref GRO_22420_47323 : N | | | |
1240 | intelnumr ID G32135372 - N1 BETTY CROCKER COFFEE ICING 2.252 SV 0.25 - 079659776 - BETTY CROCKER COFFEE ICING 400G - 201652 | | | |
1241 | intelnumr ID G32154788 - KNORR STOCK CUBES 1.51 SV 0.5 - 051021404 - KNORR FISH STOCK CUBES 8 X 10G - 201652 | | | |
1242 | claim PD 20/02/2017 TO 26/02/2017 2591627 SPAM CHOP HAM&PORK 340G | | | |
1243 | claim PD 20/02/2017 TO 26/02/2017 16535720 JRDNS NATURAL MUSLI 1KG | | | |
1244 | 21327959 BOUNTY 4 PACK 228G | | | |
1245 | 29621961 OEP S N STFF DIN KIT 312 | | | |
1246 | intelnumr ID G32174317 - N TILDA RICE 2.652 SV0.65 - 052288169 - TILDA BASMATIwir - 201652 | | | |
<tbody>
</tbody>