Em Andamento

Dates to Time Schedule Excel Macro

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.

Habilidades: Excel, Visual Basic para Apps

Ver mais: visual basic for applications, schedule source, project schedule template, project calc, excel calendar template, Visual Basic Excel, schedule calendar, libreOffice, excel visual basic, combine excel, AH, write macro, 2013 visual basic applications excel, excel row column, excel macro row, generate project file macro, 2013 excel visual basic, excel column row, excel 2013 visual, excel 2013 macro, excel file columns, libreoffice calc basic, write file excel, libreoffice basic, excel text column

Acerca do Empregador:
( 7 comentários ) Novi Marof, Croatia

ID do Projeto: #5148838

Premiar a:

jaylancer43

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 Mais

$66 USD em 3 dias
(31 Avaliações)
4.6

18 freelancers estão ofertando em média $90 para este trabalho

enamulraju

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 dias
(98 Comentários)
5.8
mrbrave

Libre Office and Excel Macro expert here....I am available to start off now and can provide macro within 8-12 hours..

$64 USD em 1 dia
(115 Comentários)
5.8
maverick44000

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 em 1 dia
(18 Comentários)
4.9
dpune

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 Mais

$111 USD in 3 dias
(17 Comentários)
4.7
zExcel

Hi, I'd be happy to help you with this macro and can start on it right away Jon -----------------------------------------------------------------------------------------------------------------

$83 USD in 0 dias
(19 Comentários)
4.6
microk

Dear Dvolaric, VBA expert here.. Please check my bid below: Bid : $45 Delivery : Within 24 Hrs. Support : Free, until it meets your requirements 100%. Best Regards, Microk http://www.extremeexcelsolutions. Mais

$45 USD in 3 dias
(29 Comentários)
4.5
swapnilchavan18

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 dias
(7 Comentários)
4.1
Edison1983

*******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 Mais

$70 USD in 0 dias
(11 Comentários)
3.7
dviruki

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 em 1 dia
(13 Comentários)
3.5
BDtW

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 a Mais

$60 USD in 3 dias
(2 Comentários)
2.7
ardiles1309

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 dias
(1 Comentário)
1.7
nikhiltechnology

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 dias
(3 Comentários)
1.8
engrawais786

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 dias
(0 Comentários)
0.0
jadenicholas00

i am very good at that,................................................................................................................................................................................................... Mais

$111 USD in 2 dias
(0 Comentários)
0.0
CARLOSHUGGINS

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 Mais

$35 USD in 3 dias
(0 Comentários)
0.0
SWAPANCHOWHAN

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 dias
(0 Comentários)
0.0
tekrangers

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 m Mais

$236 USD in 6 dias
(0 Comentários)
0.0
PereViki

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 Mais

$64 USD in 3 dias
(0 Comentários)
0.0