Alphabetize by Column

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am using Office XP.
I have a spread sheet that is in two columns. The data
is listed alphabetically by sheet, e.g. page 1 column 1
starts with items beginning with "A" then it carries over
to column 2 then page 2 column 1...ect.
Is there anyway I can get the worksheet to realpahbetize
in the order when I add net items? Currently I cut
column 2 and paster it to the bottom of column 1 and
click the "AZ" button. Then I cut and paste to return it
to the formentioned order.
 
You might could record your own custom macro to do this for you if it's
something that you do frequently......

Vaya con Dios,
Chuck, CABGx3
 
I think that calls for a DUH!

Anyone have an idea how to create one for my spreadsheet?
 
Jason

Make a backup of your workbook as it is now, just in case.

Tools>Macro>Record New Macro.

When asked where to store the macro select
"This Workbook" from the drop-down.

Go through the steps as you have described and you will build a macro.

Be sure to turn on the "Relative Reference" button before you start recording.

Stop recording when done. Hit ALT + F11 to open the Visual Basic Editor.
Select your workbook/project by name and expand(click + sign). Double-click
on Module1 to see your macro.

Since you are new to macros you should visit David McRitchie's site first for
info on macro recording and the basics.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben XL2002
 
Back
Top