excel data manipulation and sorting

[hgeek]

I just started learning VBA yesterday but this is urgent and i have no
clue as to how to do it.


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
3) i need to delete those rows i just copied in the original workbook
4) in the workbook i copied to (withoutpos.xls) i need to sort row D
ascending. i need visualbasic to look for the first blank cell in
column D and take the cells in C starting from that row and
continuing. (for example if column D has 13 filled cells and the 14th
is empty, visualbasic will tell excel to move the contents of column C
starting from C14, to column D starting with D14)
5) Now i need to sort column F ascending. i need Excel to move all
cells starting with "Email:" to column H
6) Now i need to sort column G ascending. i need Excel to move all
cells starting with "Email:" to column H
7) Now i need to resort column G and move all of it's cells that are
filled to column E
8) i need to delete G now (what was formerly column H becomes column G
now)
9) FINALLY i need to have excel take all of the text following the
second comma in column A cells and copy to column I (not H). If there
is either "MD" or "DO" in the copied text i need them to go into
column H