Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub Macro3() ' ' Macro3 Macro ' ' ActiveWorkbook.Worksheets("MatlTracker").Sort.SortFields.Clear ActiveWorkbook.Worksheets("MatlTracker").Sort.SortFields.Add Key:=Range( _ "C3:C179"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets("MatlTracker").Sort .SetRange Range("B3:C179") .Header = xlGuess .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With Range("B1:C1").Select End Sub
|Excel - only show/use data based on dates selected/entered||11||48|
|Data in Rows to be converted into single row||9||39|
|VBA in Excel to position cursor in the last row & column cell||4||26|
|Excel conditional formatting based on 'zero value'||6||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!