Find Jobs
Hire Freelancers

Dates to Time Schedule Excel Macro

$30-250 USD

Terminado
Publicado hace más de 10 años

$30-250 USD

Pagado a la entrega
Please open Excel file in attachment (its easier to explain). Definitions: - Project status Dates (PS Dates) -> Dates in columns M to AH - Project status Template (PS Template) -> Third row in Project status Dates - Time Schedule (TS) -> "Calendar" that start from Column AI This Project Goal is to write Visual Basic Macro (or LibreOffice Calc Macro) that will: - Clear Time Schedule - Go throw all PS Dates, find oldest date and write it in Cell E3 (this is TS start date) - Find newest date and generate TS to next sunday after this newest date - Copy PS Template for each PS Date to appropriate Cell in TS. In case of more equal dates then in appropriate TS Cell combine texts (use "Enter" as delimiter) and use background from the last one. Columns with blank third row (no text) are ignored. At the end I want full source for this Macro.
ID del proyecto: 5148838

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 10 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 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 zero failed projects 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 award me the project. Thanks, Jay
$66 USD en 3 días
5,0 (31 comentarios)
4,6
4,6
18 freelancers están ofertando un promedio de $90 USD por este trabajo
Avatar del usuario
i am expert in excel. i can do the work for with accuracy . waiting for your kind response to start the work. Thanks Enamul
$73 USD en 2 días
4,8 (98 comentarios)
5,8
5,8
Avatar del usuario
Libre Office and Excel Macro expert here....I am available to start off now and can provide macro within 8-12 hours..
$64 USD en 1 día
4,9 (115 comentarios)
5,8
5,8
Avatar del usuario
Hi there. Its a pretty simple task for me. I have read the details and ready to kick off with the work straight away. You shall not regret assigning the task to me. Regards
$100 USD en 1 día
5,0 (18 comentarios)
4,9
4,9
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$111 USD en 3 días
5,0 (17 comentarios)
4,7
4,7
Avatar del usuario
Hi, I'd be happy to help you with this macro and can start on it right away Jon -----------------------------------------------------------------------------------------------------------------
$83 USD en 0 día
5,0 (19 comentarios)
4,6
4,6
Avatar del usuario
I am interested to do this project. Please discuss with me before finalizing your decision. Thanks. Looking forward for long term and better relationship with you.
$100 USD en 3 días
5,0 (7 comentarios)
4,1
4,1
Avatar del usuario
*******I've done lots of similar works. I can finish your work in few mins/by max in a couple of hours***** Good Day!... I'm a VBA Programmer, having 6+ years of experience. I've developed & designed various excel based projects, templates, dashboards & trackers by using Excel VBA Macros & also with Advanced Excel Functions. Please check my project portfolio too. Kindly award me the project & come for discussion. I'll be glad to assist you. Looking forward from you. Thanks.
$70 USD en 0 día
4,5 (11 comentarios)
3,7
3,7
Avatar del usuario
Hi! I understand what needs to be done and can do it very fast. I have 12 years of Excel and VBA experience.
$56 USD en 1 día
4,9 (13 comentarios)
3,5
3,5
Avatar del usuario
Hello dvolaric, I have read your instructions and I have examined the excel file as well. I can easily do the project for you, because I have been recently doing some excel automation (Macro / VBA) recently. These automations required extensive date/time data comparisons. However if you select me for the job, I'll need to be more clear on a few issues before starting the work. They are as follows: 1. When you say "Go throw all PS Dates, find oldest date and write it in Cell E3" do you mean, all PS dates in all the rows? Rows 5,6,7,8 and 9 contain dates (in PS Dates). Shall we compare all these dates with each other? Or shall we do that on a row basis? 2. When you say "Columns with blank third row (no text) are ignored." - then shall we leave out the column "O" from this initial comparison? Or is it that, we'll include this in the comparison, but not put any template in TS (calendar)? 3."Find newest date and generate TS to next sunday after this newest date". I can do that, but please clarify what you mean by "generate TS". Is it just putting the right PS template in the date (following sunday date) in the calendar? But we have to do that for all the dates (except column O) in every row....isn't that right? Whatever you need to be done, I can write a macro for that. It shouldn't be a problem for me. So please message me if you want to clarify more, or if you want to know anything from me. Thank You and Best Regards Raad (BDtW)
$60 USD en 3 días
5,0 (2 comentarios)
2,7
2,7
Avatar del usuario
I am a chemical engineer and master excel and VBA so I can help with your assignment. I have also worked for some German companies (BASF, Roesberg), so I can easily read your spreadsheet. Best Regards
$200 USD en 5 días
5,0 (1 comentario)
1,7
1,7
Avatar del usuario
Hi I can do the programming in VBA very well as you require, I have downloaded the excel file. If you like I can deliver you this in few hours
$144 USD en 3 días
4,4 (3 comentarios)
1,8
1,8
Avatar del usuario
Hello Sir, I have gone through with your requirement and i found that our team is having very good knowledge of Excel, Visual Basic for Apps etc ... the skills are required in your current project. Lets discuss more on the same. Waiting for the assertive reply. Thanks
$236 USD en 6 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hi i understand your requirements and i can do this job for you. i m already doing excel macro works in freelancer you can see the sample in my portfolio .. please consider my bid .. thank you
$30 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
HI , I am new here but i have done this kind of project to search or specific tasks for specific events I can show u if u want . Thanks
$50 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I'm a VBA expert with over 12 year of experience... I will deliver high quality result, please take a minute and visit my profile, and check out what other employers are saying about me... thanks for considering my proposal....
$35 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i am very good at that,.............................................................................................................................................................................................................................................................................
$111 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Dvolaric, I have created a VBA macro for you that is finishing the first 3 requirements you listed in the project brief. Can you please give me some more deatils about the 4th task (Copy PS Template for each PS Date to appropriate Cell in TS. In case of more equal dates then in appropriate TS Cell combine texts (use "Enter" as delimiter) and use background from the last one.)? Maybe the best option would be if you send me an xls with the required layout. I will try to attach a sample of the functionalities we have so far (if Freelancer lets me). I am waiting for your reply. Regards, Viki
$64 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CROATIA
Novi Marof, Croatia
5,0
7
Forma de pago verificada
Miembro desde may 31, 2013

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.