Hi Alastair,

Thanks so much for your help! This is the kind of data I want to automate.

Sheet 1 contains the following data:

Capture.PNG

From this sheet, the data I care most about are 'Code' and 'Qty'. I am basically trying to transfer these two columns from sheet 1 to sheet 2 to create the following:

Capture2.PNG

So the list has just the data without any of the spacing from sheet 1. Then I want to save sheet 2 as a separate excel workbook that contains just sheet 2.

Is this possible?

Thanks for your help in advance!