Find Jobs
Hire Freelancers

Excel Spreadsheet Data Sorting - Master Data Distributed to Sub Sheets

$30-250 USD

Em Andamento
Publicado há quase 5 anos

$30-250 USD

Pago na entrega
We are a small construction company. We assign crews to work for specific superintendents on projects. We have created a spreadsheet to track which people are on which jobs for specific superintendents. All of the worksheets have been created. Here is what I need: The master worksheet has all data for each worker. When the drop down box for Superintendent is selected, all the data in that row needs to move automatically to the individual worksheet for that Superintendent. Then, the job description and name need to go to the "Dashboard" worksheet automatically. Basically, when the crew member is assigned to a Superintendent on the Master, his info is copied to 2 different worksheets. When all crew memebers are assigned they can only show up working for 1 superintendednt. A manager can look at the dashboard and see who is on each Superintendents Crew. Or he can look at a specific Superintendents worksheet for specific crew data. I have included a SAMPLE file of what the end result would look like. I did this by simply cutting and pasting, but it should all be done automatoicallly when the person is assigned to a superintendent.
ID do Projeto: 20072519

Sobre o projeto

37 propostas
Projeto remoto
Ativo há 5 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
37 freelancers estão ofertando em média $119 USD for esse trabalho
Avatar do Usuário
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD em 4 dias
4,9 (373 avaliações)
8,1
8,1
Avatar do Usuário
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will transfer all data related to a work based on the superintendent and the field staff. I plan to use a combination of formulas and VBA code to accomplish this. I will charge you $130 and can deliver within a couple of days (we can discuss the milestones, I don't require any payment in front). The delivered file will run on PCs. I'm among the most experienced and skilled Excel, and VBA developers on this platform. I am in the top 3% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$130 USD em 2 dias
4,9 (263 avaliações)
7,6
7,6
Avatar do Usuário
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD em 3 dias
4,9 (382 avaliações)
7,5
7,5
Avatar do Usuário
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$200 USD em 7 dias
4,9 (258 avaliações)
7,0
7,0
Avatar do Usuário
Hi, I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop modules that incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills, and creativity will lead to exceptional results that will exceed your expectations.
$130 USD em 2 dias
4,9 (90 avaliações)
7,1
7,1
Avatar do Usuário
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
$150 USD em 3 dias
5,0 (109 avaliações)
6,3
6,3
Avatar do Usuário
Hello there, I am an Excel expert and in this case, You will need macro/VBA script to do it. I did many projects like this before. Please contact me, I can send you some sample work of mine before and I can see how it work. Thank you.
$80 USD em 1 dia
5,0 (194 avaliações)
6,3
6,3
Avatar do Usuário
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$120 USD em 3 dias
4,8 (100 avaliações)
5,7
5,7
Avatar do Usuário
Hello, I've checked the attached files and I can write a VBA macro for this workbook to make data synchronized between these worksheets automatically. Best Regards
$50 USD em 2 dias
5,0 (64 avaliações)
5,3
5,3
Avatar do Usuário
$ 30 ONLY !!!!! Sir, I have seen your attachments and understand your requirements very well. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short time and for VERY CHEAP rate. Please CONTACT me before closing the project, I will send you a DRAFT project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$30 USD em 1 dia
5,0 (101 avaliações)
5,3
5,3
Avatar do Usuário
I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automation and develop highly dynamic and automated dashboards. I will be happy to discuss in detail how I am highly suitable for this project.
$100 USD em 2 dias
4,7 (68 avaliações)
5,7
5,7
Avatar do Usuário
Hi. Simple project. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$40 USD em 1 dia
4,8 (37 avaliações)
5,1
5,1
Avatar do Usuário
Hello Sir, I have gone through your sample attached and I will provide a well developed Excel spreadsheet for this process which will be 100% automated with smooth working capacity. I have done many process development jobs by using macros, VBA and formulas in excel. I will charge a fixed amount of $360. Kind Regards Gopal
$360 USD em 3 dias
5,0 (16 avaliações)
4,6
4,6
Avatar do Usuário
hello! let me help you with your project. I have checked your sample and I am very confident that I can help you with it. I offer high quality and accurate output with a reasonable bid amount. Hope you will consider me, thanks. P.S. I can also give you options for a better dashboard and functionality. Looking forward on hearing from you.
$100 USD em 7 dias
5,0 (30 avaliações)
4,6
4,6
Avatar do Usuário
Hi Good Day! A serious freelancer here. I've done a lot of Automated Financial and Resource Management Report Templates using MS Excel and VBA Macro. I saw your Sample file and yes I can do it in 2-3 days. Please consider my bid. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 USD em 3 dias
4,9 (43 avaliações)
4,6
4,6
Avatar do Usuário
Hi. Thanks for your request. I read your description and understood the job. I am interested to work for you. I have an experience of 6+ years in Excel, Word and VBA. Please contact me so we can discuss more about your job. If you hire me, I'll start working now. I am waiting for your response. Thanks!
$100 USD em 2 dias
5,0 (1 avaliação)
4,4
4,4
Avatar do Usuário
Available Immediately | MS Excel and VBA Expert | Assured quality of the work and timed delivery | You can check my jobs history for the same. Looking forward for your message.
$200 USD em 7 dias
5,0 (9 avaliações)
4,2
4,2
Avatar do Usuário
I am a data entry expert with advanced knowledge of Ms Excel/Google sheets. I can get your job done for you in no time once you send it to me. Let me know what you think
$61 USD em 1 dia
4,7 (9 avaliações)
3,9
3,9
Avatar do Usuário
Dear Client, I am Expert in Excel and I can make a automated program by using VBA Tool or Macros. I have excellent experience of Data entry, Web Scrapping,MS Office and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$30 USD em 1 dia
5,0 (25 avaliações)
3,8
3,8
Avatar do Usuário
Hi there, I can deliver in very low price, within 2 days or less. Just look at my profile and previous projects. Thanks.
$63 USD em 2 dias
5,0 (14 avaliações)
3,6
3,6

Sobre o cliente

Bandeira do(a) UNITED STATES
Hermitage, United States
5,0
1
Método de pagamento verificado
Membro desde fev. 18, 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.