look at your never ceasing to amaze! it's working except it's not auto filling column I after the transposition, but it's doing it for F and G. I was trying to find that part in the code to tell it myself but i'm not seeing it. Sorry to be so daft.