Hello again both,

I'm afraid i must re-awaken this thread

@jindon - Your code is not able to handle the amount of data i have, the code fails and removes data at random points
@ Norie - Yours almost does what i need your moves all the data onto one sheet.

In my workbook i have multiple sheets, each sheet relating to 1 pallet. i need the data from sheet 1 to remain on sheet 1, the same for every other sheet in the workbook (2 on 2, 3 on 3 etc etc) as the code currently collates everything onto one sheet, which prevents me from easily identifying what bit of data relates to what pallet

Could i respectfully request a re-visit?

regards