VBA to sort list automatically in alphabetical order
 

Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

VBA to sort list automatically in alphabetical order
 

Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:

Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

VBA to sort list automatically in alphabetical order
 

On Oct 6, 7:10*pm, Mike H wrote:
Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:
Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

Hi Mike,

Thanks for your help!
The code worked, but I forgot to mention earlier my source list is on
another sheet - which I have named Data List.
Is there a way of making it sort the list on this sheet? As at the
moment it sorted the column A on the sheet where I have my data
validation.

Thanks!

VBA to sort list automatically in alphabetical order
 

Hi,

Do it like this

With Sheets("Data List")
..Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending
End With


Mike

" wrote:

On Oct 6, 7:10 pm, Mike H wrote:
Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:
Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

Hi Mike,

Thanks for your help!
The code worked, but I forgot to mention earlier my source list is on
another sheet - which I have named Data List.
Is there a way of making it sort the list on this sheet? As at the
moment it sorted the column A on the sheet where I have my data
validation.

Thanks!

VBA to sort list automatically in alphabetical order
 

On Oct 6, 9:51*pm, Mike H wrote:
Hi,

Do it like this

With Sheets("Data List")
.Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending
End With

Mike

" wrote:
On Oct 6, 7:10 pm, Mike H wrote:
Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:
Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

Hi Mike,

Thanks for your help!
The code worked, but I forgot to mention earlier my source list is on
another sheet - which I have named Data List.
Is there a way of making it sort the list on this sheet? As at the
moment it sorted the column A on the sheet where I have my data
validation.

Thanks!

Hi Mike,

Thanks that works!!
Sorry to be a pain - my knowledge in VB is very limited.
I have one more probelm. My data starts from A2. A1 is a heading.
I have been trying to make it to sort from A2 but it is not working.
Do you have any suggestions??

Thanks!

VBA to sort list automatically in alphabetical order
 

Add:

Header:=xlyes

To your sort statement.

..Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending, header:=xlyes


wrote:

On Oct 6, 9:51 pm, Mike H wrote:
Hi,

Do it like this

With Sheets("Data List")
.Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending
End With

Mike

" wrote:
On Oct 6, 7:10 pm, Mike H wrote:
Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:
Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

Hi Mike,

Thanks for your help!
The code worked, but I forgot to mention earlier my source list is on
another sheet - which I have named Data List.
Is there a way of making it sort the list on this sheet? As at the
moment it sorted the column A on the sheet where I have my data
validation.

Thanks!

Hi Mike,

Thanks that works!!
Sorry to be a pain - my knowledge in VB is very limited.
I have one more probelm. My data starts from A2. A1 is a heading.
I have been trying to make it to sort from A2 but it is not working.
Do you have any suggestions??

Thanks!

--

Dave Peterson

VBA to sort list automatically in alphabetical order
 

On Oct 6, 11:49*pm, Dave Peterson wrote:
Add:

Header:=xlyes

To your sort statement.

.Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending, header:=xlyes





wrote:

On Oct 6, 9:51 pm, Mike H wrote:
Hi,

Do it like this

With Sheets("Data List")
.Columns("A:A").Sort Key1:=.Range("A1"), Order1:=xlAscending
End With

Mike

" wrote:
On Oct 6, 7:10 pm, Mike H wrote:
Hi,

Make this the last line of the routine that updates the list

Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending

Mike

" wrote:
Hi,

I am using a VBA to automatically update a source list I am using for
my data validation list as explained on the Ozgrid.com website:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

This allows the list to be automatically updated from the cells that
contain the data validation list - rather then having to go to the
source list itself. However, once the list is updated I would like it
to be automatically sorted by alphabetical order to save me time. Does
anyone know a VBA code for sorting in alphabetical order? My list is
on a seperate worksheet in column A.

Thanks for your help!

Hi Mike,

Thanks for your help!
The code worked, but I forgot to mention earlier my source list is on
another sheet - which I have named Data List.
Is there a way of making it sort the list on this sheet? As at the
moment it sorted the column A on the sheet where I have my data
validation.

Thanks!

Hi Mike,

Thanks that works!!
Sorry to be a pain - my knowledge in VB is very limited.
I have one more probelm. My data starts from A2. A1 is a heading.
I have been trying to make it to sort from A2 but it is not working.
Do you have any suggestions??

Thanks!

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks soo much! That worked!!!