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”
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>