Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a formula refer to given data even if I do a sort f. | Excel Discussion (Misc queries) | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Keeping Row 1 at the top during a Data Sort... | Excel Worksheet Functions |