Move from multiple rows to one row (two sheets)

Carl,
It is not clear to me which columns/rows you wish to merge, or delete. Try this code and let me know if this works for you

Hi Ab33.

Thanks for your time on this, and sorry for not making myself clearer.

The result of your code is close but what I'm looking for once the code has run is to see Column L, M, N, O to include the details of the second invoices.

So row 2, 3, 4, 5 are all for customer A. I want to consolidate this to one row in a new sheet (like your code) where (using your results sheet) H2:K2 equals the same invoices details you've got, Then L2:02 will equal the invoices details from the next row down (so originally from Row 3). Then row P2:S2 will have the invoices details from row 4 continuing until there is a new customer (B). which woudl then start the process again but on the next row down of the result sheet.

the tab "working sheet" gives the end result of what I would like it to look like once the code has run.

Thanks for your help and I hope this helps clear it up. (it's quite difficult to explain in text)

Carl,

(it's quite difficult to explain in text)

Yes, I understand,but would be easier if you could attach sample which shows your desired result. So, in your working sheet you could include form and layout of your desired result

Sorry Carl! Ignore my last post(#4). I can see you have attached the desired result.

Please see modified

Thank you very much..

that's brilliant!