Move descriptions

[Panoos64]

Hi all, I would like to write a VBA code so that, to run through col. “F” and rows down and where exist bold descriptions should move them to adjacent cells in col. “A”​

Therefore, that the code should start from “F11”. Below I present the original data and the expected result. Thanking you in advance

ORIGINAL DATA

	A​	B​	C ​	D ​	E ​	F​	G​	H​	J​
9​	Date​	TYPE​	CODE​	DEPARTMENT/REF.​	ENTRY #​	DEPARTMENT​		DESCRIPTION​	AMOUNT​
10​
11​	17-07-16​	RUR​	202060​	RESTAURANT 120125​	120125​	RESTAURANT​		LEMONADE SQUASH​	120.25​
12​	22-07-16​	ISS​	202075​	RESTAURANT 121255​	121255​	RESTAURANT​		REFRESHMENTS​	250.48​
13​						RESTAURANT TOTAL​			370.73​
14​
15​	12-06-18​	PUR​	202088​	POOL BAR 121230​	121230​	POOL BAR ​		ORANGE SQUASH​	108.95​
16​	17-06-18​	ISS​	202095​	POOL BAR 121345​	121345​	POOL BAR ​		GRENADINE SYRUP ​	95.45​
17​	13-07-18​	PUR​	202009​	POOL BAR 122478 ​	122478​	POOL BAR ​		ICE TEA​	150.45​
18​						POOL BAR TOTAL​			354.85​

<tbody>
</tbody>

EXPECTED RESULT

	A​	B​	C ​	D ​	E ​	F​	G​	H​	J​
9​	Date​	TYPE​	CODE​	DEPARTMENT/REF.​	ENTRY #​	DEPARTMENT​		DESCRIPTION​	AMOUNT​
10​
11​	17-07-16​	RUR​	202060​	RESTAURANT 120125​	120125​	RESTAURANT​		LEMONADE SQUASH​	120.25​
12​	22-07-16​	ISS​	202075​	RESTAURANT 121255​	121255​	RESTAURANT​		REFRESHMENTS​	250.48​
13​	RESTAURANT TOTAL ​								370.73​
14​
15​	12-06-18​	PUR​	202088​	POOL BAR 121230​	121230​	POOL BAR ​		ORANGE SQUASH​	108.95​
16​	17-06-18​	ISS​	202095​	POOL BAR 121345​	121345​	POOL BAR ​		GRENADINE SYRUP ​	95.45​
17​	13-07-18​	PUR​	202009​	POOL BAR 122478 ​	122478​	POOL BAR ​		ICE TEA​	150.45​
18 ​	POOL BAR TOTAL ​								354.85​

<tbody>
</tbody>

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1073904-move-descriptions.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.