Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
incredibly dificult formatting problem
I just started learning VBA yesterday but this is urgent and i have no
clue as to how to do it. For this excel sheet: http://www.mediafire.com/?tyxcnkdb4wd 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with dificult formula | Excel Discussion (Misc queries) | |||
why,,,, dificult?? | Excel Programming | |||
Struggling to produce INCREDIBLY simple charts with Excel (v2003) - any recommendations? | Charts and Charting in Excel | |||
Filling form text boxes from cells. Incredibly simple I know, but I'm new. :-( | Excel Programming |