Find Jobs
Hire Freelancers

Spreadsheet automation (the base is already done)

$10-30 USD

Avslutat
Publicerad ungefär fem år sedan

$10-30 USD

Betalning vid leverans
This is a spreadsheet that I already have done some macros to automate it, so I believe that most of the work is already done. Objective: to automate even more and to fix bugs How does it work: I have a program that updates the financial information of the companies I want, then I run a macro to copy the data in value in the sheet "Model", and finally I have the output in the Sheet "Cover". Problems:(i) I created the "BBG" sheet because the "WIRE" stopped calculating the formulas, so would be nice to have "WIRE" working again; (ii) In "WIRE" I would like to fill the error cells in the formula (N/A, #N/A N/A) with the previous formula (I´ve done manually in a couple cells), which should be easy to do; (iii) It´s hard to add a new stock in the spreadsheet, so I´d like something to make it easier. I think the easier way is to insert the stock ticker and the sector (e.g. yellow filled cells in the "WIRE", such as "Brazilian Financials"), and then the macro insert the information in the right spot. It´s important to be easy to add new sectors and that it works with the table in the "Cover" sheet. Would be nice to automate the table on the right side of the "cover" sheet as I add new stocks or Industries. The reset inputs should keep working as well.
Project ID: 18789832

Om projektet

11 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
11 frilansar lägger i genomsnitt anbud på $39 USD för detta uppdrag
Använd avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$100 USD Om 1 dag
4,9 (327 omdömen)
7,8
7,8
Använd avatar
Hello Sir Im excel VBA macro and formula Expert :) i can help you fix your bug in your macro Sir please ping me now and i can do it right now Thank you Galih
$30 USD Om 0 dag
4,9 (346 omdömen)
7,0
7,0
Använd avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$50 USD Om 1 dag
4,9 (298 omdömen)
6,7
6,7
Använd avatar
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$25 USD Om 0 dag
5,0 (25 omdömen)
4,0
4,0
Använd avatar
Hi dear employer, yes I can help you in this excel sheet creation. I have already done many such tasks and ready to assist you as well.
$35 USD Om 1 dag
4,9 (20 omdömen)
4,2
4,2
Använd avatar
"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards"
$50 USD Om 1 dag
4,9 (18 omdömen)
3,9
3,9
Använd avatar
I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
$20 USD Om 1 dag
5,0 (9 omdömen)
2,5
2,5
Använd avatar
I can do the job. I would need the macro worksheet to be able to fix it and modify it. I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, MS Project, Autocad, pdf, CorelDraw, etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.
$30 USD Om 2 dagar
5,0 (3 omdömen)
1,7
1,7
Använd avatar
I am a computer science teacher, and I have information aboat this projects.
$25 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, I am an expert in Excel macros and have designed complex industrial macros. I am just bidding it small because I don't think this is a big task. Hope I can help you.. regards
$10 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för BRAZIL
São Paulo, Brazil
0,0
0
Verifierad betalningsmetod
Medlem sedan feb. 22, 2019

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.