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