Ditutup

Need to build a macro

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: need build website weight loss planner, turn cell macro button excel, macro copypaste excel web site, how to create a macro in excel 2016, how to create a macro in excel 2010, excel macros for dummies, macros in excel for beginners, macro excel tutorial, use of macros in excel, excel macro examples, how to create a macro in excel 2013, need build site client will joomla help, build macro download historical prices yahoo finance, macro catia excel, macro solidworks excel, need build site videoboxcom, can build front end excel spreadsheet, excel macro find records match criteria, macro build org chart excel, i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet

Tentang Majikan:
( 0 ulasan ) Nashik, India

ID Projek: #18547572

11 pekerja bebas membida secara purata ₹6948 untuk pekerjaan ini

schoudhary1553

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. Lagi

₹12000 INR dalam 3 hari
(316 Ulasan)
7.8
usmanhassan123

Mphill In computer science having seven years of experience in Excel development and visual basics. I already done many Excel macros projects.

₹12500 INR dalam sehari
(57 Ulasan)
6.0
vsprybhanu

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 t Lagi

₹8000 INR dalam 3 hari
(81 Ulasan)
5.4
Capitan0Trueno

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 algorit Lagi

₹7787 INR dalam 2 hari
(19 Ulasan)
4.2
bhupendrayadav

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 o Lagi

₹5000 INR dalam sehari
(16 Ulasan)
4.0
Baderah

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.

₹3000 INR dalam 3 hari
(18 Ulasan)
3.5
muralidaran84

I am having Microsoft certified C# developer, having 10 years of Exp. in C# software development. Please let me if you are interested. Thanks

₹12500 INR dalam 3 hari
(5 Ulasan)
3.2
boscojfelix

Dear Sir, I have a solution for your problem. But I have two question. 1. Why do you prefer freelancers from India. 2. Why do you need my GSTIN number.

₹2611 INR dalam sehari
(4 Ulasan)
2.6
mfaiz01

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 Lagi

₹8000 INR dalam 3 hari
(2 Ulasan)
0.5
richardoyelabi

Hi. I have ample experience with visual basic for applications using Microsoft Excel. I think I can create the macro you want. Please, send me the details and I will tell you if I can do it or not. Thanks.

₹2777 INR dalam 2 hari
(0 Ulasan)
0.0
mdraut

Hi, I can Do your work, Please provide the Excel sheet. It seem that it can be done much earlier. Thanks

₹2250 INR dalam 3 hari
(0 Ulasan)
0.0