Shift cells up then delete empty rows

[makinmomb]

I want the date to finally look like this

23-01-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 50000.00
25-01-2017 BEING PAID FOR FUEL FOR T 170 CBB Cash Payment 100000.00
25-01-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 90000.00
30-01-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 80000.00
01-02-2017 BEING PAID FOR FUEL FOR T 170 CBB Cash Payment 80000.00
03-02-2017 BEING PAID FOR FUEL FOR T 913 BJL Cash Payment 50000.00
04-02-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 100000.00
07-02-2017 BEING PAID FOR FUEL FOR T 170 CBB Cash Payment 100000.00
09-02-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 80000.00
13-02-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 100000.00
14-02-2017 BEING PAID FOR FUEL FOR T 170 CBB Cash Payment 100000.00
14-02-2017 BEING PAID FOR FUEL FOR T 473 BHR Cash Payment 46500.00
16-02-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 100000.00
20-02-2017 BEING PAID FOR FUEL FOR T 473 BHR Cash Payment 44300.00
21-02-2017 BEING PAID FOR FUEL FOR T 490 AYD Cash Payment 100000.00
22-02-2017 BEING PAID FOR FUEL FOR T 170 CBB Cash Payment 80000.00

[makinmomb]

From this attached file

[makinmomb]

So the macro need to shift date there once upwards and then it will delete rows not required

[KOKOSEK]

Try:

Please Login or Register  to view this content.

[makinmomb]

Thank u very much

[jolivanes]

Just for the heck of it, with SpecialCells.

Please Login or Register  to view this content.