Completed

Excel Macro (vba program) Modification

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]".

Skills: Excel, Visual Basic for Apps, Excel Macros, Excel VBA, Visual Basic

See more: excel macro lock program day trial, example excel macro vba invoicexls forum, excel macro vba select copy paste internet explorer, excel macro vba functions cut paste, excel macro vba odbc querytable, excel macro vba find word, check add install excel macro vba, excel macro vba freelance job, excel macro vba coding, excel macro vba subdirectories, copy internet explorer paste excel macro vba, create form excel macro vba, excel macro vba import csv text file, excel macro vba rewriting, excel macro vba tree, excel macro vba unicode string, form excel macro vba time clock, import msp project data excel macro vba, excel macro paste program, sap excel macro vba

About the Employer:
( 9 reviews ) JUNAGARH, India

Project ID: #20927116

Awarded to:

Prompty

Hi, i have opened your files and understood your requirement. I can do this job of NFO and Stock at 15 mins interval.

₹1500 INR in 3 days
(1 Review)
0.6

7 freelancers are bidding on average ₹1500 for this job

Panggumsok

Hi, I am pleasure to edit excel document with sheet function and VBA. And I've made the VB program for simple task. Your require stimulates me. I think we can chat for detail.

₹3000 INR in 1 day
(1 Review)
0.3
AntonSerg15

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 More

₹1050 INR in 7 days
(0 Reviews)
0.0
Anatoly1995

Hello sir, I have gone through your requirements. I have much experience in this field. I am sure that I can finish your project as you want. So please come up on chat and share with me. ------------------------------ More

₹1050 INR in 7 days
(0 Reviews)
0.0
swathiaeil

I work at home in proper manner and Fastly Relevant Skills and Experience I does not have any experience ,i am started work newly .

₹1300 INR in 7 days
(0 Reviews)
0.0
swadhinaswain

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 , experien More

₹1050 INR in 1 day
(0 Reviews)
0.0
irenerebecca91

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.

₹1550 INR in 3 days
(0 Reviews)
0.0