Find Jobs
Hire Freelancers

Microsoft Excel - Visual Basic Code help

$10 AUD

In Progress
Posted over 5 years ago

$10 AUD

Paid on delivery
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, _ Orientation:=xlTopToBottom End If End Sub 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 then, 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
Project ID: 17892981

About the project

10 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $38 AUD for this job
User Avatar
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.
$15 AUD in 10 days
4.8 (18 reviews)
4.7
4.7
User Avatar
"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$50 AUD in 3 days
5.0 (18 reviews)
4.3
4.3
User Avatar
Hello, Kindly provide me your email id and I will provide you with the code which not only will sort the data as per your requirements, but also will automatically put borders to all the data. The code is not fitting in this window, that is the reason why I am asking you for your email ID. I have no issues, if you do not pay me, at least my code will help someone in need. Thanks & Regards Satish Chandra
$10 AUD in 1 day
4.8 (2 reviews)
1.6
1.6
User Avatar
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.
$15 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
this is my full price
$222 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$25 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam, You asked for solutions in the proposal. This can be done by adding another column with the formula: =IF(O2="Yes",2,IF(L2="Yes",1,0)) You can then use the filter keys to sort column A by A-Z then this new column by A-Z. These filters will need to be redone after each time you type in "Yes". It is possible to have the order update automatically, but this would use a macro and I would need to use the real spreadsheet (or a dummy version of it with confidential information censored) to check the work. Yours faithfully, Emma
$10 AUD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Newcomb, Australia
5.0
27
Payment method verified
Member since Jul 3, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.