Create a separate workbook using data from another workbook.

Hi macro_noob3030

Probably the easiest way is not to use macros!

I am assuming that if there is data in column A, then there will be data in B through to (whatever) and likewise if there is nothing in column A then that row is completely blank.

Copy from sheet 1 A1 : last row last column to Sheet 2 B1

In column A number from 1 to last row used

Sort whole sheet on column B.

This will put all blank rows at the bottom of the data. Delete these rows

Sort whole sheet on column A (to put back in original order)

Delete column A

Delete Sheet 1

Save As (New name)

If you would like this automated by means of a macro, let me have a sample of your data and I will write such a macro

Regards
Alastair

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!