Alphabetize by Column

[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.

 

[CLR]

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

 

[Jason]

I think that calls for a DUH!

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

 

[Gord Dibben]

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