Find Jobs
Hire Freelancers

Need to build a macro

₹1500-12500 INR

Закрито
Опублікований about 5 years ago

₹1500-12500 INR

Оплачується при отриманні
We have an excel sheet which contains the following summary sections - 1) New_Credit_Facility_Summary 2) Credit_Profile_Summary 3) Borrower_Summary 4) Additional_Status_Summary These summary sections are created based on the data available in 'Account Details' sheet. We need to build a macro which upon execution (some trigger like cell change etc.) will create hyperlinks for each of the values in these 4 summary sections - for each cell column 'E' onwards. Once the respective hyperlink is clicked, it should navigate to the 'Account Details' sheet and automatically filter the 'Account_Details' sheet based on the criteria that matches the cell which is clicked in that particular Summary. The macro should be made generic, as the rows in 'Account_Details' sheet will vary. However, the structure of summary sections will remain same. Attaching sample '[login to view URL]' file for reference. Pre-requisites- 1. Freelancer should be from India. 2. Freelancer should have GSTIN.
ID проекту: 18547572

Про проект

9 пропозицій(-ї)
Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
9 фрілансерів(-и) готові виконати цю роботу у середньому за ₹7 893 INR
Аватарка користувача
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
₹12 000 INR за 3 дні(-в)
4,9 (424 відгуки(-ів))
8,2
8,2
Аватарка користувача
Mphill In computer science having seven years of experience in Excel development and visual basics. I already done many Excel macros projects.
₹12 500 INR за 1 день
4,8 (91 відгуки(-ів))
6,4
6,4
Аватарка користувача
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Earnest and Young also. You can get your work done here with highest quality at lowest price. I accept only once you are fully satisfied with the work done. I have GSTIN Looking forward to work with you
₹5 000 INR за 1 день
4,9 (43 відгуки(-ів))
5,7
5,7
Аватарка користувача
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I can design macros as per your requirements, to create hyperlinks to navigate specific sheets. Macro will be flexible for varying rows and columns. So, No matter how many rows or columns. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
₹8 000 INR за 3 дні(-в)
4,8 (116 відгуки(-ів))
5,9
5,9
Аватарка користувача
It does not seem a difficult job. MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
₹7 787 INR за 2 дні(-в)
5,0 (42 відгуки(-ів))
5,2
5,2
Аватарка користувача
I am financial analyst and an expert in Ms excel. Therefore, I can fulfill all your Ms excel related need. For more details, contact me.
₹3 000 INR за 3 дні(-в)
4,5 (26 відгуки(-ів))
3,9
3,9
Аватарка користувача
I am having Microsoft certified C# developer, having 10 years of Exp. in C# software development. Please let me if you are interested. Thanks
₹12 500 INR за 3 дні(-в)
5,0 (5 відгуки(-ів))
3,2
3,2
Аватарка користувача
Hi, I am a professional macro developer and can implement the requirement. Your requirement is to create hyperlinks and then filter the data based in 'Account Details' sheet based on the trigger cell value. Please award this project to me and I am sure to deliver this project with high quality. Please message me for any queries. Thanks. Best Regards Mohd F
₹8 000 INR за 3 дні(-в)
5,0 (4 відгуки(-ів))
1,2
1,2
Аватарка користувача
Hi, I can Do your work, Please provide the Excel sheet. It seem that it can be done much earlier. Thanks
₹2 250 INR за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор INDIA
Nashik, India
0,0
0
На сайті з груд. 16, 2008

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.