Using a MACRO to sort data
 

Is there a way to use a Macro in an Excel Workbook that would allow me to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub


--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
Is there a way to use a Macro in an Excel Workbook that would allow me to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

I completely agree with Don Guillett's answer, but I must say, if you haven't
ever created a macro, I highly recommend you to read
http://office.microsoft.com/training...RC011506201033
(macro tutorial, about 30-50 minutes).

And also, don't put the two period (..) before Range.
Hope that helps.

Greetings from México!

"Don Guillett" wrote:

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub


--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
Is there a way to use a Macro in an Excel Workbook that would allow me to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

I didn't put .. before range......... ONLY 1 .

--
Don Guillett
SalesAid Software

"Mexage" wrote in message
...
I completely agree with Don Guillett's answer, but I must say, if you
haven't
ever created a macro, I highly recommend you to read
http://office.microsoft.com/training...RC011506201033
(macro tutorial, about 30-50 minutes).

And also, don't put the two period (..) before Range.
Hope that helps.

Greetings from México!

"Don Guillett" wrote:

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub


--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
Is there a way to use a Macro in an Excel Workbook that would allow me
to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

well, if you didn't, it does appear that way in your original post... check
it out

:-D

"Don Guillett" wrote:

I didn't put .. before range......... ONLY 1 .

--
Don Guillett
SalesAid Software

"Mexage" wrote in message
...
I completely agree with Don Guillett's answer, but I must say, if you
haven't
ever created a macro, I highly recommend you to read
http://office.microsoft.com/training...RC011506201033
(macro tutorial, about 30-50 minutes).

And also, don't put the two period (..) before Range.
Hope that helps.

Greetings from México!

"Don Guillett" wrote:

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub


--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
Is there a way to use a Macro in an Excel Workbook that would allow me
to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

Before I answered, I did but it wasn't in my macro or it wouldn't have
worked..............................

--
Don Guillett
SalesAid Software

"Mexage" wrote in message
...
well, if you didn't, it does appear that way in your original post...
check
it out

:-D

"Don Guillett" wrote:

I didn't put .. before range......... ONLY 1 .

--
Don Guillett
SalesAid Software

"Mexage" wrote in message
...
I completely agree with Don Guillett's answer, but I must say, if you
haven't
ever created a macro, I highly recommend you to read

http://office.microsoft.com/training...RC011506201033
(macro tutorial, about 30-50 minutes).

And also, don't put the two period (..) before Range.
Hope that helps.

Greetings from México!

"Don Guillett" wrote:

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub


--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
Is there a way to use a Macro in an Excel Workbook that would
allow me
to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.