vba macro development

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I own a company and we need to work our data better, I am looknig to take a dump of data from our system on a daily basis and this will be saved on our cloud server say at 6.30am, then a VBA Macro will take that data and using another spreadsheet, this will add some columns and some new values to these new columns, with the guidance of the other spreadsheet. this includes 2 simple sums, one is an add of two columns and the other is a multiple of two columns, one of which is one that you would have created, once this has been finished, I want the text colour changed from Red to Black if a value in a set cell if less that today's date. The Macro will overwrite some data in one column and then sort the file by that column and produce a 4 tab report for each owner, so each row of Data has an Owner, the name owner will have more than 1 row, the demo data uploaded is circa 1200 line and there are 15 owners. it repeats this task every work day an produces the report, the number of owners can change, the code pushed to the CSV file can change daily to provide flexability, I have written a detailed Spec and attached examples of the real data which I have anonymised.

Any questions I would be happy to set up a call.

Excel Software Architecture Visual Basic Visual Basic for Apps

Project ID: #18435606

About the project

12 proposals Remote project Active 5 years ago

Awarded to:

seaanddream

Hi, my name is Selim. I am from Solihull, UK. I read your `vba macro development` project descriptions carefully before bidding. I checked the attached templates and samples as well... I got what you need and ready to More

£825 GBP in 5 days
(309 Reviews)
8.0

12 freelancers are bidding on average £1000 for this job

zekovicm

Hi there, As an Excel VBA expert i would like to help you with this project. Please feel free to contact me to discuss further details. Best regards Miljan

£1176 GBP in 7 days
(144 Reviews)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

£1200 GBP in 10 days
(246 Reviews)
7.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

£750 GBP in 5 days
(141 Reviews)
6.5
macroPOL

Hello, I am Excel and VBA expert. I can do it. I can start today and finish in few days If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on More

£750 GBP in 7 days
(98 Reviews)
6.1
KashirinA

Dear client I have good skills about vba If u want me ,I will show good result for u I have good review for u I have rich experience about your job I m very interesting of your job My review is very good for yo More

£1250 GBP in 20 days
(21 Reviews)
5.6
superbpartner

Hi,dear! I am quite interested in your project - 'vba macro development'. :) I am a skillful software developer who has rich experience in this field. If you contact me, you and I will be happy. Thank you in advance. More

£1250 GBP in 7 days
(11 Reviews)
4.7
ska5761b99170406

Dear Sir, I have gone thru your requirements and i believe i am an excellent candidate for this project, I have recently worked on a similar project, i am an excel expert with 11+ years of experience i have deviced More

£750 GBP in 20 days
(6 Reviews)
2.8
simoreings24

je suis disponible a l'instant ;je suis competence dans ce domaine et j'espere tu accepte moi pour faire cette projet avec un methode tres professionel avec plusieurs avantages

£1250 GBP in 10 days
(0 Reviews)
0.0