Find Jobs
Hire Freelancers

Dates to Time Schedule Excel Macro

$30-250 USD

Fullført
Lagt ut over 10 år siden

$30-250 USD

Betalt ved levering
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.
Prosjekt-ID: 5148838

Om prosjektet

18 forslag
Eksternt prosjekt
Aktiv 10 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
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 om 3 dager
5,0 (31 omtaler)
4,6
4,6
18 frilansere byr i gjennomsnitt $90 USD for denne jobben
Brukeravatar
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 om 2 dager
4,8 (98 omtaler)
5,8
5,8
Brukeravatar
Libre Office and Excel Macro expert here....I am available to start off now and can provide macro within 8-12 hours..
$64 USD om 1 dag
4,9 (115 omtaler)
5,8
5,8
Brukeravatar
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 om 1 dag
5,0 (18 omtaler)
4,9
4,9
Brukeravatar
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 om 3 dager
5,0 (17 omtaler)
4,7
4,7
Brukeravatar
Hi, I'd be happy to help you with this macro and can start on it right away Jon -----------------------------------------------------------------------------------------------------------------
$83 USD om 0 dag
5,0 (19 omtaler)
4,6
4,6
Brukeravatar
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 om 3 dager
5,0 (7 omtaler)
4,1
4,1
Brukeravatar
*******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 om 0 dag
4,5 (11 omtaler)
3,7
3,7
Brukeravatar
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 om 1 dag
4,9 (13 omtaler)
3,5
3,5
Brukeravatar
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 om 3 dager
5,0 (2 omtaler)
2,7
2,7
Brukeravatar
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 om 5 dager
5,0 (1 omtale)
1,7
1,7
Brukeravatar
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 om 3 dager
4,4 (3 omtaler)
1,8
1,8
Brukeravatar
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 om 6 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
i am very good at that,.............................................................................................................................................................................................................................................................................
$111 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

CROATIAs flagg
Novi Marof, Croatia
5,0
7
Betalingsmetode bekreftet
Medlem siden mai 31, 2013

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.