Find Jobs
Hire Freelancers

Spreadsheet automation (the base is already done)

$10-30 USD

Đã đóng
Đã đăng vào khoảng 5 năm trước

$10-30 USD

Thanh toán khi bàn giao
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.
Mã dự án: 18789832

Về dự án

11 đề xuất
Dự án từ xa
Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
11 freelancers are bidding on average $39 USD for this job
Avatar người dùng
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 trong 1 ngày
4,9 (327 nhận xét)
7,8
7,8
Avatar người dùng
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 trong 0 ngày
4,9 (346 nhận xét)
7,0
7,0
Avatar người dùng
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 trong 1 ngày
4,9 (298 nhận xét)
6,7
6,7
Avatar người dùng
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 trong 0 ngày
5,0 (25 nhận xét)
4,0
4,0
Avatar người dùng
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 trong 1 ngày
4,9 (20 nhận xét)
4,2
4,2
Avatar người dùng
"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 trong 1 ngày
4,9 (18 nhận xét)
3,9
3,9
Avatar người dùng
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 trong 1 ngày
5,0 (9 nhận xét)
2,5
2,5
Avatar người dùng
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 trong 2 ngày
5,0 (3 nhận xét)
1,7
1,7
Avatar người dùng
I am a computer science teacher, and I have information aboat this projects.
$25 USD trong 2 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của BRAZIL
São Paulo, Brazil
0,0
0
Phương thức thanh toán đã xác thực
Thành viên từ thg 2 22, 2019

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.