View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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.