Find Jobs
Hire Freelancers

Spreadsheet automation (the base is already done)

$10-30 USD

Lukket
Slået op cirka 5 år siden

$10-30 USD

Betales ved levering
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.
Projekt-ID: 18789832

Om projektet

11 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
11 freelancers are bidding on average $39 USD for this job
Brug 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 på 1 dag
4,9 (327 anmeldelser)
7,8
7,8
Brug 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 på 0 dag
4,9 (346 anmeldelser)
7,0
7,0
Brug 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 på 1 dag
4,9 (298 anmeldelser)
6,7
6,7
Brug 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 på 0 dag
5,0 (25 anmeldelser)
4,0
4,0
Brug 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 på 1 dag
4,9 (20 anmeldelser)
4,2
4,2
Brug 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 på 1 dag
4,9 (18 anmeldelser)
3,9
3,9
Brug 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 på 1 dag
5,0 (9 anmeldelser)
2,5
2,5
Brug 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 på 2 dage
5,0 (3 anmeldelser)
1,7
1,7
Brug Avatar.
I am a computer science teacher, and I have information aboat this projects.
$25 USD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for BRAZIL
São Paulo, Brazil
0,0
0
Betalingsmetode verificeret
Medlem siden feb. 22, 2019

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.