vba for alphanumerically sorting column

imisy3d

New Member
Joined
Sep 3, 2013
Messages
19
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1820"]
<colgroup><col span="2"><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]1[/TD]
[TD] [/TD]
[TD="align: left"]How Have You Been? [/TD]
[TD="align: left"]Receptive communication[/TD]
[TD="align: left"]Dialogue (2)[/TD]
[TD="align: left"]Unit 1, Lesson 5[/TD]
[TD] [/TD]
[TD="align: left"]Michelle Lapides, Kenneth Ness, Andrew Weidig[/TD]
[TD]x[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]168[/TD]
[TD] [/TD]
[TD="align: left"]Role-Shifting Three Characters: Me explain do-do to 3 different people[/TD]
[TD="align: left"]ASL Up Close (role shifting 3 characters)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Andrew Weidig[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]169[/TD]
[TD] [/TD]
[TD="align: left"]Role-Shifting Three Characters: Marathon winners[/TD]
[TD="align: left"]ASL Up Close (role shifting 3 characters)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Andrew Weidig[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]170[/TD]
[TD] [/TD]
[TD="align: left"]Planning a Party[/TD]
[TD="align: left"]Action Communication 15[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 3, Lesson 3[/TD]
[TD] [/TD]
[TD="align: left"]Monique Holt[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]171[/TD]
[TD] [/TD]
[TD="align: left"]Four Days Left[/TD]
[TD="align: left"]Action Communication 18[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 3, Lesson 5[/TD]
[TD] [/TD]
[TD="align: left"]Luisray Aguilar[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]172[/TD]
[TD] [/TD]
[TD="align: left"]A Day in My Life in 2040 1[/TD]
[TD="align: left"]Receptive communication[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 10, Lesson 1[/TD]
[TD] [/TD]
[TD="align: left"]Colin Analco[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]173[/TD]
[TD] [/TD]
[TD="align: left"]A Day in My Life in 2040 2[/TD]
[TD="align: left"]Receptive communication[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 10, Lesson 1[/TD]
[TD] [/TD]
[TD="align: left"]Pali Dacanay[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]174[/TD]
[TD] [/TD]
[TD="align: left"]Survey Perspective: Map - Home look like what. ******* on left, bedroom down hall. [/TD]
[TD="align: left"]ASL Up Close: Survey Perspective (map)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Aimee Sever[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]484[/TD]
[TD] [/TD]
[TD="align: left"]Survey Perspective: Map - Restaurant there. Parking lot nearby. [/TD]
[TD="align: left"]ASL Up Close: Survey Perspective (map)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Aimee Sever[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]485[/TD]
[TD] [/TD]
[TD="align: left"]You're a Winner![/TD]
[TD="align: left"]ASL Up Close (surprise)[/TD]
[TD="align: left"]Dialogue (2)[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Michelle Lapides, Katasha Walker[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]486[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]Introduction to The Candle[/TD]
[TD="align: left"]The Lion & Other Stories[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Robert Rivera[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]491[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]Introduction to The Hotel[/TD]
[TD="align: left"]The Lion & Other Stories[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Robert Rivera[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]493[/TD]
[TD] [/TD]
[TD="align: left"]Surprise: [surprised face, mouth open. Up close][/TD]
[TD="align: left"]ASL Up Close (surprise)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Norma Moran[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]494[/TD]
[TD] [/TD]
[TD="align: left"]Surprise: Recent watch TV, click-remote-control++. See news. Orange-eyes why? Spot my friend win fs-lotto![/TD]
[TD="align: left"]ASL Up Close (surprise)[/TD]
[TD="align: left"]Example[/TD]
[TD="align: left"]Where? (Unit, Lesson)[/TD]
[TD] [/TD]
[TD="align: left"]Norma Moran[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1640[/TD]
[TD] [/TD]
[TD="align: left"]Trip to Mexico[/TD]
[TD="align: left"]ABC Story[/TD]
[TD="align: left"]Literature[/TD]
[TD="align: left"]Unit 1, Lesson 1[/TD]
[TD] [/TD]
[TD="align: left"]Dennise Scott[/TD]
[TD]x[/TD]
[TD="align: left"]Blurry. Looks odd. [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1641[/TD]
[TD] [/TD]
[TD="align: left"]Abbe de l’Epee[/TD]
[TD="align: left"]Receptive communication[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 1, Focus[/TD]
[TD] [/TD]
[TD="align: left"]Michelle Lapides[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1642[/TD]
[TD] [/TD]
[TD="align: left"]Home Layout Description 1[/TD]
[TD="align: left"]ASL Up Close (layout)[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"]Unit 2, Lesson 2[/TD]
[TD] [/TD]
[TD="align: left"]Michelle Lapides[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1643[/TD]
[TD] [/TD]
[TD="align: left"]Jack and the Beanstalk[/TD]
[TD="align: left"]Story[/TD]
[TD="align: left"]Literature[/TD]
[TD="align: left"]Unit 10, Lesson 1[/TD]
[TD] [/TD]
[TD="align: left"]Robin Shannon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1644[/TD]
[TD] [/TD]
[TD="align: left"]My Dream Vacation[/TD]
[TD="align: left"]Receptive communication[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 1, Lesson 1[/TD]
[TD] [/TD]
[TD="align: left"]Thomas Welch[/TD]
[TD]x[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1645[/TD]
[TD] [/TD]
[TD="align: left"]Italian Story[/TD]
[TD="align: left"]Story[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]Unit 8, Lesson 2[/TD]
[TD] [/TD]
[TD="align: left"]Joette Paulone[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1646[/TD]
[TD] [/TD]
[TD="align: left"]Flower Pot at Pennsylvania School for the Deaf[/TD]
[TD="align: left"]Not using[/TD]
[TD="align: left"]Monologue[/TD]
[TD="align: left"]N/A, N/A[/TD]
[TD] [/TD]
[TD="align: left"]Joette Paulone[/TD]
[TD]Not needed[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]907g[/TD]
[TD="align: left"]v5179[/TD]
[TD="align: left"]The Rise of Oralism [/TD]
[TD="align: left"]486-***[/TD]
[TD="align: left"]Taking Care of Yourself[/TD]
[TD="align: left"]Unit 4, Focus [/TD]
[TD="align: left"]Deaf Awareness Ad (v5179)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]907h[/TD]
[TD="align: left"]v5180[/TD]
[TD="align: left"]Discovering Deaf Identity[/TD]
[TD="align: left"]491-***[/TD]
[TD="align: left"]Taking Care of Yourself[/TD]
[TD="align: left"]Unit 4, CTD[/TD]
[TD="align: left"]Identity (v5180)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]907i[/TD]
[TD="align: left"]v5181[/TD]
[TD="align: left"]Audism[/TD]
[TD="align: left"]907g-v5179[/TD]
[TD="align: left"]In My Free Time[/TD]
[TD="align: left"]Unit 5, Toolbox[/TD]
[TD="align: left"]The Deaf Man (v5181)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]907j[/TD]
[TD="align: left"]v5182[/TD]
[TD="align: left"]Double Minority: Black Deaf[/TD]
[TD="align: left"]907h-v5180[/TD]
[TD="align: left"]I Think….[/TD]
[TD="align: left"]Unit 6, Focus[/TD]
[TD="align: left"]Pay Attention (v5182)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]907k[/TD]
[TD="align: left"]v5183[/TD]
[TD="align: left"]Deaf Places[/TD]
[TD="align: left"]907i-v5181[/TD]
[TD="align: left"]I Think….[/TD]
[TD="align: left"]Unit 6, Toolbox[/TD]
[TD="align: left"]Rocky Mountain Deaf School (v5183)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908a[/TD]
[TD="align: left"]v5184[/TD]
[TD="align: left"]Crime & Punishment[/TD]
[TD="align: left"]907j-v5182[/TD]
[TD="align: left"]News & Current Events[/TD]
[TD="align: left"]Unit 8, Lesson 2[/TD]
[TD="align: left"]First Responder (v5184)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908aa[/TD]
[TD="align: left"]v5185[/TD]
[TD="align: left"]Talking About Government & Politics [/TD]
[TD="align: left"]907k-v5183[/TD]
[TD="align: left"]News & Current Events[/TD]
[TD="align: left"]Unit 8, Lesson 5[/TD]
[TD="align: left"]Elections Canada (v5185)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908b[/TD]
[TD="align: left"]v5186[/TD]
[TD="align: left"]Collectivism[/TD]
[TD="align: left"]908a-v5184[/TD]
[TD="align: left"]News & Current Events[/TD]
[TD="align: left"]Unit 8, CTD[/TD]
[TD="align: left"]Am I the only Deaf Teenager? (v5186)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908bb[/TD]
[TD="align: left"]v5187[/TD]
[TD="align: left"]Unusual Jobs[/TD]
[TD="align: left"]908aa-v5185[/TD]
[TD="align: left"]The Work World[/TD]
[TD="align: left"]Unit 9, Lesson 3[/TD]
[TD="align: left"]Deaf Mugger (v5187)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908c[/TD]
[TD="align: left"]v5188[/TD]
[TD="align: left"]Rhyme[/TD]
[TD="align: left"]908b-v5186[/TD]
[TD="align: left"]Exploration 1 (Rhyme & Rhythm) [/TD]
[TD="align: left"]Exploration 1, Lesson 1[/TD]
[TD="align: left"]Three Little Pigs (v5188)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908cc[/TD]
[TD="align: left"]v5189[/TD]
[TD="align: left"]Rhyme & Rhythm Together [/TD]
[TD="align: left"]908bb-v5187[/TD]
[TD="align: left"]Exploration 1 (Rhyme & Rhythm) [/TD]
[TD="align: left"]Exploration 1, Lesson 3[/TD]
[TD="align: left"]Grouchy Monkey (v5189)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908d[/TD]
[TD="align: left"]v5190[/TD]
[TD="align: left"]Rhyme & Rhythm Together [/TD]
[TD="align: left"]908c-v5188[/TD]
[TD="align: left"]Exploration 1 (Rhyme & Rhythm) [/TD]
[TD="align: left"]Exploration 1, Lesson 3[/TD]
[TD="align: left"]ASL Song - Thanksgiving (v5190)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908dd[/TD]
[TD="align: left"]v5191[/TD]
[TD="align: left"]The Rise of Oralism [/TD]
[TD="align: left"]908cc-v5189[/TD]
[TD="align: left"]Taking Care of Yourself[/TD]
[TD="align: left"]Unit 4, Focus [/TD]
[TD="align: left"]Oralists' Lies (v5191)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908e[/TD]
[TD="align: left"]v5192[/TD]
[TD="align: left"]Discovering Deaf Identity[/TD]
[TD="align: left"]908d-v5190[/TD]
[TD="align: left"]Taking Care of Yourself[/TD]
[TD="align: left"]Unit 4, CTD[/TD]
[TD="align: left"]Pointless: Big D, Small D (v5192)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908ee[/TD]
[TD="align: left"]v5193[/TD]
[TD="align: left"]Bio: George Veditz[/TD]
[TD="align: left"]908dd-v5191[/TD]
[TD="align: left"]Taking Care of Yourself[/TD]
[TD="align: left"]Unit 4, Toolbox[/TD]
[TD="align: left"]Who is George Veditz? (v5193)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908f[/TD]
[TD="align: left"]v5194[/TD]
[TD="align: left"]You Have to Be Deaf to Understand [/TD]
[TD="align: left"]908e-v5192[/TD]
[TD="align: left"]I Think….[/TD]
[TD="align: left"]Unit 6, CTD[/TD]
[TD="align: left"]Yellow Diamond-Shaped (v5194)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]908ff[/TD]
[TD="align: left"]v5195[/TD]
[TD="align: left"]Talking About Government & Politics [/TD]
[TD="align: left"]908ee-v5193[/TD]
[TD="align: left"]News & Current Events[/TD]
[TD="align: left"]Unit 8, Lesson 5[/TD]
[TD="align: left"]Why are we not politically active (v5195)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908g[/TD]
[TD="align: left"]v5196[/TD]
[TD="align: left"]Workplace Problems & Solutions [/TD]
[TD="align: left"]908f-v5194[/TD]
[TD="align: left"]The Work World[/TD]
[TD="align: left"]Unit 9, Lesson 4[/TD]
[TD="align: left"]nTouch Advertisement (v5196)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]908h[/TD]
[TD="align: left"]v5197[/TD]
[TD="align: left"]The Future of the Deaf Community[/TD]
[TD="align: left"]908ff-v5195[/TD]
[TD="align: left"]Changing Times[/TD]
[TD="align: left"]Unit 10, CTD[/TD]
[TD="align: left"]The End (v5197)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

please check it, i want to sort column A Alphanumerically and all other columns adjust automatically according to sorting of A column

any body can help

its urgent
thx
 
hi how are you
sir
today i again need you help
file is here ...
1. As a general rule, I choose not to download files from other sites to look at or answer questions here.

2. If it is a different question, then you would be best to start a new thread.
 
Upvote 0

Forum statistics

Threads
1,226,848
Messages
6,193,315
Members
453,790
Latest member
yassinosnoo1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top