Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
sorting data from one tab on another
I have a spread sheet with a list of users sorted alphabetically. I'd like
to sort that data by userID on a different tab. Problem is, I don't want to manually do it. Is there a way to have the 'ID sorted tab' automatically update and sort itself as I make changes to the 'alphabetical tab'? Thanks for your help! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
sorting data from one tab on another
Put this in Worksheet code for Sheet1:
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub End If Application.EnableEvents = False Sheets("sorted").Range("A:A").Clear Sheets("Sheet1").Range("A:A").Copy Sheets("sorted").Range("A1") Sheets("sorted").Range("A:A").Sort key1:=Sheets("sorted").Range("A1") Application.EnableEvents = True End Sub Whenever data is changed in column A in Sheet1, the data is automatically copied over to sheet "sorted" and sorted. -- Gary''s Student - gsnu200718 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data | Excel Discussion (Misc queries) | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
sorting data with ; | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Need help Sorting data | Excel Worksheet Functions |