Find Jobs
Hire Freelancers

Excel Macro (vba program) Modification

₹600-1500 INR

Completed
Posted over 4 years ago

₹600-1500 INR

Paid on delivery
Uploaded here is a programmed excel file. It extracts specific data from two files which starts with name - NSEFO-********.csv, kept at one folder. When clicked on generate, it first selects the oldest file and extracts data, which ends with "[login to view URL]" from column A and time "03.29.59 PM" and pastes in result file. It then selects the newest file and extracts the same names from column A of result file, but with time 09.29.59 AM, 09.59.59 AM, 10:29:59 AM and so on at an interval of half an hour till 03.29.59 PM and pastes in result file. Here two NSEFO_**** files are uploaded as samples. Modifications required. 1. The program selects data from column A of source whose name ends with : [login to view URL] It has to be modified so that it selects : -I ,when [login to view URL] is not present. 2. From the newest file it extracts data at an interval of 30 minutes, it has to be modified so that it extracts data at an interval of 15 minutes. i.e.09.29.59 AM, 09.44.59 AM, 09.59.59 AM, 10:14:59 AM 10:29:59 AM and so on till 03.29.59 PM 3. I have uploaded two additional files with format NSESSTOCK-*****.csv, and kept in same folder as the earlier source files. Now data from the above two files needs to be extracted as well and paste in row starting from 250 as mentioned in "result [login to view URL]" file. The time selection will be same as earlier (column A from oldest and rest columns from newest file). Only different is that, names should be selected from column A of already executed result file and trimming "-I" or "[login to view URL]".
Project ID: 20927116

About the project

5 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
Hi, i have opened your files and understood your requirement. I can do this job of NFO and Stock at 15 mins interval.
₹1,500 INR in 3 days
5.0 (3 reviews)
1.7
1.7
5 freelancers are bidding on average ₹1,290 INR for this job
User Avatar
Hi How are you doing today? I have read your project detail very carefully and I have the confidence to complete this on time perfectly. Although I am a new freelancer I have rich experience in this field. If you want I'll explain or show my ability. What is most important is to know what you want. I know your need. if you have some uncleared thing, may ask to me. I will answer perfectly. If you hire me, I'm sure you will be satisfied. Thank you.
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work at home in proper manner and Fastly Relevant Skills and Experience I does not have any experience ,i am started work newly .
₹1,300 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a good person and I completed my work with in the time and it's helpfull to you sir . Please give me this work I do this job in the better way Relevant Skills and Experience PGDCA complete , Excel user , experience of 2 year in offline job
₹1,050 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked for top MNC's and I have hands on experience in Excel and reporting. I can rest assure that I can finish this work by the promised with no errors.
₹1,550 INR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
JUNAGARH, India
5.0
11
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.