I have a MS Excel workbook that I use on a daily basis. (screen grab attached).
I have a job number in column A that automatically sorts A-Z each time I create a new entry.
This is achieved using some advice I found on the internet....
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("A2:A200")) Is Nothing Then
Range("A1").Sort Key1:=Range("A200"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
What I would like to do is add some more conditions to this.
In column L I have a "completed" value - I type YES once the job is completed and conditional formatting turns it green
In column O I have an "archive" value - I Type YES once I am done with the job.
I would like the sheet to automatically sort my data by...
Column A A-Z with where there is no values in L & O
Any rows with values in L
then, any rows with values in O
If you can please paste the code in to your proposal. First response with code that works I'll award & pay
13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
I AM SPECIALIST IN EXCEL, IT WOULD BE A PLEASURE TO HELP YOU. FROM WHAT I SEE, IN THE PROPOSAL IT IS A SIMPLE CORRECTION IN THE CODE. I LIKE YOU WITH COLLABORATION. I HAVE IT READY IN THREE TO FOUR HOURS.
Hi, It is a simple work. As it is possible for me to check whether the solution is working or not I expect you to award the project first, I will be able to give you solution exactly what you are expecting.