Hi mate,

Thanks for the fix, I've used those and made the perfect template to add +2 and HD channels.

I actually use the #N/A error to tell me the channels that don't have a HD or +2, so the process is really easy now (I've made it do it like a machine).

1. Paste data into grey area.
2. Sort by Channel.
3. Scroll right to what looks like an exact replica of the gret area, but it has the adjusted dates, times and channels (by simply doing an '=cell' in all of it).
4. Copy and 'paste values' all of that into a new tab, sort it AGAIN by channel (so all the #N/A is at the bottom).
5. Copy all data up until the last available channel (all up to the first #N/A).
6. Paste into the original Macro file I have.

This is how I do it for the +2, and it's basically the same for the HD (but it only needs a look-up table, no crazy complicated formula for the date and time!).

So thanks a ton for the help, if you live in Australia I owe you a pint!