Enter description next to a number

[Panoos64]

Hi all, i would like to write a vba so that where in col. "D" the number start from number 92 and in col. "F" is the category "BEVERGAE" should place on number's right side "APERITIF" and if in col. "F" and it start from 92 should place "SPICES" and so on.

In sch.1. are the original data and in sch.2. is the expected result.

Many thanks in advance

SCH.1.

	A	B	C	D	E	F
1	DATE	TYPE	REF.1	REF.2	TR. NO	CATEGORY
2	03-02-17	ISSUE		92145		BEVERAGE
3	10-05-17	ISSUE		92505		BEVERAGE
4	10-05-17	ISSUE		92800		BEVERAGE
5	10-05-17	ISSUE		92905		FOOD
6	10-05-17	ISSUE		92608		HOT BEVERAGE
7	10-05-17	ISSUE		92700		HOT BEVERAGE

<colgroup><col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2048;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> </colgroup><tbody>
</tbody>

SCH.2.

	A	B	C	D	E	F
1	DATE	TYPE	REF.1	REF.2	TR. NO	CATEGORY
2	03-02-17	ISSUE		92145 APERITIF		BEVERAGE
3	10-05-17	ISSUE		92505 APERITIF		BEVERAGE
4	10-05-17	ISSUE		92800 APERITIF		BEVERAGE
5	10-05-17	ISSUE		92905 SPICES		FOOD
6	10-05-17	ISSUE		92608 COFFEE		HOT BEVERAGE
7	10-05-17	ISSUE		92700 COFFEE		HOT BEVERAGE

<colgroup><col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2048;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> </colgroup><tbody>
</tbody>

 

[Panoos64]

Hi Marcelo, both of them work. I am sorry if i was bother you. As i said i wanted to improve my knowledge. Thanks once again. Have a nice day!