Rabu, 14 September 2011

[ExcelVBA] CODE TO SORT A RANGE, CREATE SHEETS AND TRANSFER INFO

 

I work with this spreadsheet on a daily basis with 5 columns and over 4,000 rows

BLOCK ID NAME COMPANY
LO-1A-2-1 010990 Justus Elawe TCM 1
LO-1A-2-2 001762 Toju Ebietan TCM 1
LO-1A-2-3 010126 ROBINSON OSAINOR TCM 1
LO-1A-2-4 011406 OMASAN JUMI TCM 1
LO-1A-2-5 011803 ESIFE ELIJAH TCM 1
LO-1A-2-6 012076 TUNDE OJENIYI TCM 1

LO-1A-37-15 015424 DELIS UMUKORO TCM 1
LO-1A-37-16 007912 FRANCIS OGHALA TCM 1
LO-1B-14-1 008250 JUNIOR WARIBERE TCM 1
LO-1B-14-2 008110 OMOSOMOFA BENSON TCM 1
LO-1B-14-3 009490 Polycarp AsulelimhenTCM 1

LO-2BN-20-15 013998 SOLOMON UGBEYE JAD 1
LO-2BN-20-16 014000 FAMOUS ATIRENE JAD 1
LO-2BS-1-1 015736 OMONOLA OMOJOYE DNL 1
LO-2BS-1-2 012639 Anslem Ofor Eriata DNL 1
TOTAL 4368

I need a code to sort the data based on the criteria (LO-1A, LO-1B, LO-2AN,...LO-2FS into 17 sheets, so equally named to include the headings and Total (Summation)

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar