Find Jobs
Hire Freelancers

Microsoft Excel - Visual Basic Code help

$10 AUD

W trakcie realizacji
Opublikowano ponad 5 lat temu

$10 AUD

Płatne przy odbiorze
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
Identyfikator projektu: 17892981

Informację o projekcie

10 ofert
Zdalny projekt
Aktywny 5 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
10 freelancerzy składają oferty o średniej wysokości $38 AUD dla tej pracy
Awatar Użytkownika
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 w 10 dni
4,8 (18 opinii)
4,7
4,7
Awatar Użytkownika
"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 w 3 dni
5,0 (18 opinii)
4,3
4,3
Awatar Użytkownika
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 w 1 dzień
4,8 (2 opinii)
1,6
1,6
Awatar Użytkownika
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 w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
this is my full price
$222 AUD w 5 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 0 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
Newcomb, Australia
5,0
27
Zweryfikowana metoda płatności
Członek od lip 3, 2015

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.