VBA Macro to decode a string into specific format

I have a very large set of infrared codes that were used on a Philips pronto remote, i would like to be able to convert these codes into a different format. There are around 8K rows of data

The pronto code is placed in column "E" and the resultant converted result appears in "G,H,I, J" where G is the device 1 command, H is the device 2 command only applicable when the sting is a 20 bit, I is the actual command and J is the number of bits in the string.

The enclosed worksheet is how i managed to decode them, but would like to create a macro that would decode the pronto string and give me the 4 required outputs.
This will allow me to convert all the codes i have, which will allow me to then convert them into another format which i know how to use.
I have tried creating macros but i just don't know what i am doing

Any help appreciated

You could use also this code:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks Karedog,
That works fine, however if a row has null data in "E" how would the output rows display nothing instead of 0, 0, 0, -1?

Many thanks to you both for your assistance