Find Jobs
Hire Freelancers

Excel Automation for search

₹600-1500 INR

Completed
Posted about 5 years ago

₹600-1500 INR

Paid on delivery
I have uploaded here an macro enable excel file. It has been programmed to search data from another excel file "source"(changeable). The macro programmed here is password protected and password is unknown. There are 15 search items(D15 to D29) in the NSEFO_RESULT file. After clicking run macro in the NSEFO_RESULT file, a search page appears. When a search item is copied into search windows, after clicking search it searches all the data from the source file, and when clicked "listviewtoexcel" it adds data in the result book. The process is being repeated manually one by one and data gets added to result book of same file. A macro needs to be developed so that it AUTOMATICALLY copies first item into search box, then clicks search, then clicks "listviewtoexcel" to add data pertaining to that item in the result book. then repeat the process for 2nd item, 3rd item and so on.
Project ID: 18541957

About the project

2 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
Awarded to:
User Avatar
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
₹1,500 INR in 1 day
4.8 (105 reviews)
5.8
5.8
2 freelancers are bidding on average ₹1,475 INR for this job
User Avatar
I have a macro which can unlock any sheet/workbook even if the password is unknown. My bio is below. Craig has very strong skills in Excel and as well as being an advanced user, comfortable with all facets of the software, has ran excel training groups and provided email helpline support for Excel issues across companies he has worked for. He has vast experience building advanced Excel models to be used in industry (energy, financial and public sectors) and very much enjoys coming up with solutions and problem-solving issues relating to data management and visualisation. Craig’s Excel experience involves building various models (to request) to present or convey data/information to clients. This not only involves using advanced functions (vlookup, hlookup, match, index, array functions etc.) but also paying close attention to quality control and quality assurance procedures when building a model/workbook.
₹1,450 INR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
JUNAGARH, India
5.0
9
Payment method verified
Member since Feb 6, 2014

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.