Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$30-250 USD

Concluído
Publicado há aproximadamente 7 anos

$30-250 USD

Pago na entrega
My team at work downloads hundreds of excel workbooks every day. We have been individually highlighting, sorting, etc. to make the workbook appear a certain way before we send it off to our customers. Rather than doing each sheet manually, can you help me create a Macro for excel that would do what we need? There are 14 Columns: Shipped Chip, Enrolled Chip, Pet Name, Service Level, Enrollment Date, Status, Expiration Date, Ship To – SPAH, Ship To – SAP, Enroll By - SPAH, Enroll By – SAP, Package Number, Ship Date, Free Chip INDC. We need to do the following steps in this order: 1. IF “Enrollment Date” is anything other than “-” AND “Service Level” is “None” AND “Status” is “-” THEN the row needs to be highlighted in orange from column A through column N. 2. Columns D, F, G, H, J, and N need to be deleted. (Service Level, Status, Expiration Date, Ship To – SPAH, Enroll By - SPAH, Free Chip INDC). 3. The remaining columns (A:H) need to be adjusted to full-width. 4. IF “Shipped Chip” is “-” THEN the row needs to be highlighted in light blue from column A through column H. 5. The remaining columns (A:H) need to be adjusted to full-width. 6. IF “Enrolled Chip” is “-” THEN the row needs to be highlighted in yellow from column A through column H. 7. The entire worksheet should be sorted by three levels. First by “Ship Date” Newest to Oldest, then by “Package Number” A to Z, and lastly by “Enrollment Date” Newest to Oldest. After all of that is done, then we save it on our desktop and email it to the appropriate customer. Is this too much for a single Macro? What can be done in VBA? I will need to copy/share this Macro so up to ten other computers can use it as well.
ID do Projeto: 13214207

Sobre o projeto

7 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, I am a scholar from Indian Institute of Technology, Delhi, one of the most premier engineering institutes of India. I am highly proficient with excel, and hence I will be able to complete the task in 3 days. Please message me once before awarding this award so that I can clear your doubts. Thanks
$50 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
7 freelancers estão ofertando em média $166 USD for esse trabalho
Avatar do Usuário
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, Hope you are all well. Dear, I’ve read through your project description very carefully and attentively. I am very much interested in your project with all of your requirements. Please send me the details in the pm. looking forward to working with you. I am a hardworking and Expert MS Excel professional. I have Extensible knowledge about Data Entry With a great quality and in time. Hope you care about project quality. I am looking for my first opportunity. Grant me this project will put my heart and soul for the project. Thanks
$45 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I have more than 8 years of experience in wide range of web & mobile designing and development services. I have expertise in all aspects of website design and development (including mobile) and have been involved in several small and large projects from the start to finish. Over the last 8 years, I have delivered hundreds of projects related to array of Web-Based Application, Mobile Based Application, Website Design, Software Architecture, API Development, Social Media Development, E-commerce Development, Social Media Integration, CMS Development etc. using the advanced and most appropriate web technologies. I work specially in PHP and .Net platform to bring the best possible end product. I have great experience in Open Source Content Management System like Drupal, Magento, Joomla, WordPress, .NET and MVC Object Oriented Framework such as Codelgniter, Zend, CakePHP, Qcodo, and PRADOTM for the startup and small businesses. My other areas of expertise include E-commerce website and app with payment gateway integration; API Development with RestFul API (Protocol), OAuth1.0/2.0 (Facebook, Google, LinkedIn), SAML/SSO, OpenID, XML (SOAP) & WSDL; Mobile Development for iOS and Android; Social Media API like Facebook, Twitter, Google Analytics & Google Adwords Apps; Payment API like PayPal, Wepay. I am an expert of security based applications. I also have the experience in Windows and Linux server management. Kind Regards Izza
$177 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Lincoln, United States
5,0
1
Método de pagamento verificado
Membro desde fev. 24, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.