I will assume you are doing a formula in your secondary sheets that picks up the values in the master sheet .
In a seconday sheet you have a formula like this in A1 =MasterSheet1!A1 and in B1 =MasterSheet1!B1 etc...
if this is the case all you have to do is use this code to Sort your master sheet range A!:AM100 in Ascending order.
Note: this does not work on them just hitting the enter key . I think you would cause a bunch of unexpected troubles if you go that route. make you a shortcut key combination to run the code or put a button control on your master sheet and assign the macro to it.
You will also need to change Sheet1 in the code to match the name of your Master Sheet name.
Code:
Sub Sort_Asc()
'
' Sort_Asc Macro
'
'
Columns("A:AM").Select
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("A1"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A1:AM100")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("A1").Select
End Sub
Bookmarks