Thread
:
Using a MACRO to sort data
View Single Post
#
2
Don Guillett
Posts: n/a
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 With Quote