Find Jobs
Hire Freelancers

Need to build a macro

₹1500-12500 INR

Closed
Posted about 5 years ago

₹1500-12500 INR

Paid on delivery
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.
Project ID: 18547572

About the project

9 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹7,893 INR for this job
User 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
₹12,000 INR in 3 days
4.9 (424 reviews)
8.2
8.2
User Avatar
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 in 1 day
4.8 (91 reviews)
6.4
6.4
User Avatar
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 in 1 day
4.9 (43 reviews)
5.7
5.7
User Avatar
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 in 3 days
4.8 (116 reviews)
5.9
5.9
User Avatar
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 in 2 days
5.0 (42 reviews)
5.2
5.2
User Avatar
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 in 3 days
4.5 (26 reviews)
3.9
3.9
User Avatar
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 in 3 days
5.0 (5 reviews)
3.2
3.2
User Avatar
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 in 3 days
5.0 (4 reviews)
1.2
1.2
User Avatar
Hi, I can Do your work, Please provide the Excel sheet. It seem that it can be done much earlier. Thanks
₹2,250 INR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Nashik, India
0.0
0
Member since Dec 16, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.