Find Jobs
Hire Freelancers

Write some Software

$30-250 USD

Terminado
Publicado hace alrededor de 8 años

$30-250 USD

Pagado a la entrega
Make an Excel spreadsheet to create a monthly report. The file structure will be as attached but it must be portable so that it can be accessed from different locations or moved between servers. The file called "MONTHLY DESIGN REPORT" will have a macro to import all of the Excel files in the "Project Reports" subdirectory as worksheets within "MONTHLY DESIGN REPORT". The Excel files in the "Project Reports" directory can have any name and there might be any number. The tab names in these excel files will be named for each project and these names will link back to the REPORT worksheet. Look in the TEMPLATE directory for example files. Each month we will create a new directory, named by month. We will place the "MONTHLY DESIGN REPORT" within this directory. We will place the individual reports received back from each project in the "Project Reports" directory. We will then run the macro in "MONTHLY DESIGN REPORT" which will import all of the project reports and summarise them. You need to comment your code and the received code must not be locked in any way. If you have suggestions for improvements to give more flexibility that will be a bonus.
ID del proyecto: 10074382

Información sobre el proyecto

24 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
Hi I have checked the sample attachment. I believe you want to import all individual worksheets from from "Projects Reports" folder into the MONTHLY DESIGN REPORT file for each month. I can work on this and include a button to execute this with one click. I have mentioned the tentative time of 5 days. If you want this urgently, I can take this up on priority. Please send me a personal message to discuss this further. Thanks Abhishek
$35 USD en 5 días
4,8 (10 comentarios)
3,8
3,8
24 freelancers están ofertando un promedio de $174 USD por este trabajo
Avatar del usuario
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$200 USD en 3 días
5,0 (497 comentarios)
8,0
8,0
Avatar del usuario
Hello there, I am an expert in creating Excel based automated dashboards/reports. I have showcased some of my works in my profile and have done several other professional quality reports for clients across the globe. As you would see in my work history, the clients I work with are very happy with my work and have been associated with me for multiple projects. I have delivered more than 500 excel projects on different freelancing sites and have been consistently rated excellent. I reviewed the requirements brief you shared and have a good understanding of what you are looking for and how it should be done. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. I can assure you of a very efficient process that will work on click of one or few buttons. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$166 USD en 7 días
4,9 (110 comentarios)
6,3
6,3
Avatar del usuario
Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you for your time.
$185 USD en 4 días
4,9 (106 comentarios)
5,8
5,8
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 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping 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 Webscrapping, 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.
$178 USD en 3 días
4,8 (70 comentarios)
5,8
5,8
Avatar del usuario
HI I am an excel-vba Expert and I can help you with your project pm me ...................................................................................................................
$222 USD en 3 días
5,0 (37 comentarios)
5,3
5,3
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$155 USD en 3 días
4,7 (14 comentarios)
5,0
5,0
Avatar del usuario
Hi, i can do what you need, I have experience in a similar priject where I create .pdf files in a folder bases in the diferent charts generated for changes in data values. you can see ia video in my profile with this name: ATOMATIC PDF CREATIONS BASED ON SPREADSHEETS. I know just what you need, please let us chat if you consider I am your candidate,
$85 USD en 3 días
5,0 (21 comentarios)
4,7
4,7
Avatar del usuario
Local Australian with extensive excel/vba experience in an reporting and analytics. Ive worked as an operations and logistics analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solutions to drive optimisation. Im confident I can tailor a solution for you that is not only functional, efficient, dynamic and innovative. It is my day job to consult and improve operational processes.
$222 USD en 2 días
3,9 (3 comentarios)
3,5
3,5
Avatar del usuario
We at LumiNysis are expert in Excel, Access, VBA and automation across industries and are able to covert any data into useful results Please provide us an opportunity to cater your request on high priority.
$100 USD en 1 día
5,0 (2 comentarios)
1,9
1,9
Avatar del usuario
Dear Sir/Madam, I would be glad to help you with this project. I will do my best to meet your expectations. Best regards, Jana V.
$155 USD en 3 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hi, I'm a Computer Programmer by profession. I'm adept at making MS Excel Softwares. I can get this job well-done for you in the given time and within your budget. Thanks.
$250 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm an expert VBA developer who has the skills and experience to make your spreadsheets relate to one another and produce the reports you need.
$255 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have read your description of the project and also try to open attachment but unable to open, there is some problem, but I have done work in excel so I can do. Thanks
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi. It's very interesting project for me. I will do it with pleasure. I have a question. Must Macro to check subdirectories on existence if you run it multitimes or macro build new sheets every time? For example. I open MONTHLY DESIGN REPORT, run macro. Macros will create some sheets. Then i'll run macro againg. Macro creates this sheets again, or check it on existence in MACRO DESIGN REPORT? Best Regards.
$45 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My expertise in Microsoft excel, Visual basic and python & my academic qualification of engineering make s me qualified for this project.
$222 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
AS understood i´ll make an excel worksheet that contains a macro to read other excel sheets put in a directory to bring data to the main one (MONTHLY REPORT), then it has to take data from all of this projects to the summary report. I will contain, a summary tab, a tab for each project and a macro, using the template given
$170 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My extensive excel and VBA knowledge as well as experience in automating/ improving spreadsheets will assist me to complete the job at hand in the allocated time.
$250 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Tonypandy, United Kingdom
5,0
8
Forma de pago verificada
Miembro desde ene 20, 2007

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.