Hello Arnelgp,

Yes I'm aware of that, thank you, as per my original message I did state:

'Yes I know the code below won't copy over in same format 3 x 6, one step at a time for me as I'm new to VBA lol'

I was trying to get it to work first the easier way before I then tried to replicate the 3 x 6 format, once I got it copy to correctly to A1:B18 and can then sort out the correct formatting, once step at a time for me as I'm still learning and was hoping for some help from this forum, unfortunately your message isn't offering any help