Find Jobs
Hire Freelancers

Build Macros in an EXCEL sheet to automatically populate data from a Master Sheet

$30-250 USD

Terminado
Publicado hace alrededor de 8 años

$30-250 USD

Pagado a la entrega
See attached document tracking Sheet. The first sheet is the master schedule where all data pertaining to drawings is populated. There are four additional sheets that contain data pulled from the master sheet. The project is to automate the data population of the sheets: "Drawing Checkout Tracking" "IFA Submission" "IFC Submission" "As-Built Submission" Use the data already populated in the sheets to understand what the requirements are. Requirements: 1. All data must automatically populate using a macro or some other automated process. If needed, you can put in a "button" that retreives the data on each sheet so the automation process happens only when desired. 2. The print formatting of the four sheets above must remain intact and be ready to print at any time To qualify: 1. Review the attached sheet and provide a description on how you intend to approach the problem 2. Provide me an example of your work, either by modifying the sheet provided or by showing me similar work you have done.
ID del proyecto: 9607670

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello, I think I am the perfect candidate for working on this project. I am proficient in Excel and VBA and macros and I would love to show you example of my work. Please contact me for more details.
$121 USD en 3 días
4,9 (137 comentarios)
5,8
5,8
19 freelancers están ofertando un promedio de $104 USD por este trabajo
Avatar del usuario
Hi! Do you use one file for one project ? Please send me chat so that I can attach sample file. .
$150 USD en 3 días
5,0 (353 comentarios)
7,4
7,4
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$140 USD en 7 días
4,9 (204 comentarios)
7,3
7,3
Avatar del usuario
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already developed such dynamic reporting tools for various business. If you are comfortable with my ratings and reputations, please send me the information to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$250 USD en 3 días
5,0 (186 comentarios)
6,7
6,7
Avatar del usuario
Hi A warm greetings! Thank you for the opportunity to submit a proposal in your job post. Please give me more details so that i could understand the project specification very well. I always work with perfection, fast and on budget. Waiting for your reply! Regards
$155 USD en 3 días
4,8 (137 comentarios)
6,5
6,5
Avatar del usuario
Hello, I am Excel and VBA expert. I can complete this project. I want to write a macro (VBA). I have done many similar projects - retrieve data from one sheet to another in an automatic way. Here are some examples: https://www.freelancer.pl/projects/project-9575884/ https://www.freelancer.pl/projects/php/Excel-Macro-9120719/ https://www.freelancer.pl/projects/Software-Architecture/Excel-VBA-Script-that-Compares/ https://www.freelancer.pl/projects/Excel/Excel-sheet-needed-based-two/ Please note that I have 100% completion rate and 5-star feedback on projects.
$100 USD en 3 días
5,0 (95 comentarios)
6,0
6,0
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$54 USD en 3 días
4,8 (75 comentarios)
5,9
5,9
Avatar del usuario
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within some hours. If you open a chat I cand send you a working mockup of your required spreadsheet immediately. Regards
$45 USD en 1 día
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
Hi, I am a professional in EXCEL and VBA and VB.net programming so I can help you with this project in minimal time. as I have worked on similar projects many times. what i am thinking of is a simple VB..NET tool that will handle all this process, as this will be much faster and flexible more than VBA note: check my first project https://www.freelancer.com/projects/User-Interface-IA/Program-Interface/ Regards.
$150 USD en 1 día
5,0 (30 comentarios)
5,4
5,4
Avatar del usuario
Hello sir, I go through your project description and found it simply doable. I have understood exactly what you want. I have been working on this type of projects from last few years. I have a team of 15 operators with me, who are very much efficient in MS Excel, copy paste, web extracting and various other data entry works. My team members are fast and accurate. We also do a quality check before sending the work to our clients. We promise to work with complete honesty, dedication and devotion. We are well known for on time delivery and accuracy. We are in the position of starting the work immediately, as we have a team. We can discuss more through PM. We are available on skype, hangout, and other messaging sites also. We are ready to send a sample of the prescribed work, before being hired. We assure of 100% accuracy. Hope to hear positive from you Thanks & Regards, Joy C TechnoVin India
$44 USD en 3 días
5,0 (6 comentarios)
2,3
2,3
Avatar del usuario
We at LumiNysis are the expert in MS Excel, VBA and automation across industries and are able to covert any data into useful results
$35 USD en 2 días
5,0 (2 comentarios)
1,9
1,9
Avatar del usuario
Hi Kevin here, I hope you will consider our team for your project. We will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from you soon and if you have any queries please do not hesitate to message us and we can talk. thanks
$144 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm an expert on MS Excel. I offer to write a code, which first of all will check whether new rows have been added to the master sheet. Is so, then for eache sheet an array wiil be created, which will contain the info from the master sheet according to the columns of each sheet to fil in. And, of course, the sheets with the criteria in columns Q,R,S from the master sheet will be filled in only it the condition is met.
$70 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$45 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Irvine, United States
5,0
42
Forma de pago verificada
Miembro desde sept 12, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.