Hi There,

What i need to do is that
1) Sort by column B so that the cells with numbers come out on top, it
is a sort ascending function
2) i need to find a way for visualbasic to know that i only want to
select up to the last cell in column B that starts with numbers. I
need to then take all of the cells from A1 until HX (where X is the
row number of the last numerical B cell) and copy it and paste it to
another workbook named withoutpos.xls
Column B in your examle file does not contain any numbers??

Could you confirm which columns you are referring to and maybe show the result you are expecting on another sheet in you example file.

Thanks

Marshybid