Find Jobs
Hire Freelancers

Dates to Time Schedule Excel Macro

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 5148838

About the project

18 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 3 days
5.0 (31 reviews)
4.6
4.6
18 freelancers are bidding on average $90 USD for this job
User Avatar
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 in 2 days
4.8 (98 reviews)
5.8
5.8
User Avatar
Libre Office and Excel Macro expert here....I am available to start off now and can provide macro within 8-12 hours..
$64 USD in 1 day
4.9 (115 reviews)
5.8
5.8
User Avatar
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 in 1 day
5.0 (18 reviews)
4.9
4.9
User Avatar
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 in 3 days
5.0 (17 reviews)
4.7
4.7
User Avatar
Hi, I'd be happy to help you with this macro and can start on it right away Jon -----------------------------------------------------------------------------------------------------------------
$83 USD in 0 day
5.0 (19 reviews)
4.6
4.6
User Avatar
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 in 3 days
5.0 (7 reviews)
4.1
4.1
User Avatar
*******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 in 0 day
4.5 (11 reviews)
3.7
3.7
User Avatar
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 in 1 day
4.9 (13 reviews)
3.5
3.5
User Avatar
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 in 3 days
5.0 (2 reviews)
2.7
2.7
User Avatar
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 in 5 days
5.0 (1 review)
1.7
1.7
User Avatar
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 in 3 days
4.4 (3 reviews)
1.8
1.8
User Avatar
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 in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am very good at that,.............................................................................................................................................................................................................................................................................
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CROATIA
Novi Marof, Croatia
5.0
7
Payment method verified
Member since May 31, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.