Tamamlanmış

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

Beceriler: Excel, Uygulamalar için Visual Basic, Excel Macros, Excel VBA, Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 9 değerlendirme ) JUNAGARH, India

Proje NO: #20927116

Seçilen:

Prompty

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

%selectedBids___i_period_sub_7% gün içinde 1500%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
0.6

Bu iş için 7 freelancer ortalamada ₹1500 teklif veriyor

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(1 Yorum)
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 Daha Fazla

₹1050 INR in 7 gün içinde
(0 Değerlendirme)
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. ------------------------------ Daha Fazla

₹1050 INR in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
0.0