ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Morning.
In my workbook i have two worksheets.
On my worksheet "HONDA SHEET" data is entered into certain cells.
These cells are arranged A-Z
Like so,
ACCORD ID48
CRV ID46
JAZZ ID8E
STREAM ID8E
In the other worksheet "INFO" the same data is shown but currently in order of smallest to largest so i can see which items are selling better than others,this is sorted from a macro button on "HONDA SHEET"
Like so,
JAZZ ID 8E 37
ACCORD ID48 20
CRV ID46 4
STREAM ID8E 1
This is my goal for today.
As data is entered into the cells on "HONDA SHEET" automatically update them on "INFO" sheet.
I will have a macro button on "HONDA SHEET" which will take me to the "INFO" sheet BUT show me the items from smallest to largest.
Please can you advise me some pointers.
Im lost as to how the cells are updated from one sheet to the other because each time i use the macro button the "INFO SHEET" cell data will be constantly moving there location and showing me the selling popularity of sold items.
Example
If cell AV4 is ACCORD ID48 but then i sell a few of them and now its new location is cell AV1, how does the code that updates the "INFO" sheet know to now update the ACCORD ID48 in cell AV1 and not AV4 ??
Where i mention macro button it will just be press button then take me to the page in question,the main bit is files be updated & arranged each time.
Please advise.
In my workbook i have two worksheets.
On my worksheet "HONDA SHEET" data is entered into certain cells.
These cells are arranged A-Z
Like so,
ACCORD ID48
CRV ID46
JAZZ ID8E
STREAM ID8E
In the other worksheet "INFO" the same data is shown but currently in order of smallest to largest so i can see which items are selling better than others,this is sorted from a macro button on "HONDA SHEET"
Like so,
JAZZ ID 8E 37
ACCORD ID48 20
CRV ID46 4
STREAM ID8E 1
This is my goal for today.
As data is entered into the cells on "HONDA SHEET" automatically update them on "INFO" sheet.
I will have a macro button on "HONDA SHEET" which will take me to the "INFO" sheet BUT show me the items from smallest to largest.
Please can you advise me some pointers.
Im lost as to how the cells are updated from one sheet to the other because each time i use the macro button the "INFO SHEET" cell data will be constantly moving there location and showing me the selling popularity of sold items.
Example
If cell AV4 is ACCORD ID48 but then i sell a few of them and now its new location is cell AV1, how does the code that updates the "INFO" sheet know to now update the ACCORD ID48 in cell AV1 and not AV4 ??
Where i mention macro button it will just be press button then take me to the page in question,the main bit is files be updated & arranged each time.
Code:
Sub LEADERBOARD()'
' LeaderBoard Macro
'
'
Sheets("INFO").Select
Range("AV1").Select
ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort.SortFields.Add Key:=Range( _
"AW1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortTextAsNumbers
With ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub