Đã hoàn thành

Excel VBA for DATA IMPORT FROM .TXR FILES to excel file

There will be six .txt files in a specified folder namely :

NIFTY, BANKNIFTY, CNX-IT, CNXFMCG, NIFTYAUTO, CNXENERGY

Each file contains 1 minute intraday historical data for one month.

Task of VBA ------

There should be option to enter a specific date in the format YYYYMMDD.

When a specific is entered the vba should extract data of same day from 9.16 to 3.30 and data of previous day from 2.01 to 3.30 and finally feed the data in output excel file/sheet. One by one data from all six files of folder needs to be extracted in the same manner.

The format of output excel sheet is uploaded.

Suppose I have entered date : 20201202, then output data should be as per the format in uploaded sample output file.

Kĩ năng: Excel, Excel VBA

Về khách hàng:
( 16 nhận xét ) JUNAGARH, India

ID dự án: #33779188

Được trao cho:

Yorkflying

Hi, I will be able to finish this work in 1 day. I specialize in Excel and VBA/Macro in Excel, Word, and Outlook with 20 years' experience. I will perform any tasks in MS office to automate your business. Excel, VBA m Thêm

₹600 INR trong 1 ngày
(5 Đánh Giá)
3.4

26 freelancer chào giá trung bình₹1496 cho công việc này

(182 Nhận xét)
7.0
(108 Nhận xét)
6.3
merinsinha

Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this pl Thêm

₹2550 INR trong 1 ngày
(135 Nhận xét)
5.6
(73 Nhận xét)
5.0
MamukaB

Hi I can do this job within few hours or within day and can start work now. It's easy job for me, as I'm doing like this jobs my regular work I have 15+ year experience of Excel, Excel VBA and Have 100% feedback So, yo Thêm

₹1500 INR trong 1 ngày
(26 Nhận xét)
4.6
abatsis

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Data Entry, IoT, Industrial IoT, Power Thêm

₹1500 INR trong 4 ngày
(15 Nhận xét)
4.3
vnegi2016

Hi, My name is Vikram, gone through your requirement extract and update information from text files. I can help you to create a VBA Automation as per conditions and requirements. I am having expertise and experienc Thêm

₹2000 INR trong 5 ngày
(15 Nhận xét)
2.3
tabsamcgo

hello, this is my first time doing this freelance kind of job if you will give me a chance to try this i will make sure to do my job perfectly right

₹800 INR trong 7 ngày
(0 Nhận xét)
0.0
aditigarg20024

Hi,I would love to work on your project.I read through the job details carefully and I am absolutely sure that I can do the project very well I can achieve the results that you are asking for on time. If you award me t Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
bsbindus5

Highly accurate data entry professional with 12 years of experience, seeking freelance projects. Detail-Oriented data entry professional with 10-Key Typing Speed of 15,000 KPH with zero errors. Maintained 99% accuracy Thêm

₹1000 INR trong 7 ngày
(0 Nhận xét)
0.0
Gsdsheetal

Hello I am New Here but I have over 5+ experience in Data Entry and Research plus Content Writing. I am sincere and Hardworking. Please give me a chance to work with you. Best Regards Sheetal

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
vaibhav5959

I'm an accountant having 4 years of work experience in accounting, data entry operating, excel, word, English typing speed 30,40. I will do complete your work as soon as possible and carefully.

₹3000 INR trong 40 ngày
(0 Nhận xét)
0.0
profmberia

I am confident that I am a good fit for this position for several reasons, but most specifically because of my dedication to going above and beyond in a job. I am committed to learning any new skills on my own to succe Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
muhammadsaim1419

Hello there, I've read your description and can build the expense management and profit for you. you'll be to manage your business expenses and earing easily using that. can you let me know a bit more about the pro Thêm

₹1100 INR trong 7 ngày
(0 Nhận xét)
0.0
meghwalchatrara9

I am a data entry operator and I have experience to do this job. I also have experience of working excel, ws word, pdf etc. for last 2 years. And I hope that you will understand my responsibility.

₹1050 INR trong 6 ngày
(0 Nhận xét)
0.0
nishathakur61012

I am student i know to do tele calling or excel entry or data entry i am hardworker or smartworker..

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
rtkgameinggamin4

killed in planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support Thêm

₹600 INR trong 7 ngày
(0 Nhận xét)
0.0
saimshk63

I do this work with honest I do this job like I thought it's not your I think it's own my work so I can do this job with great devotion.

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
Shivraj358

Excel Hi, My name is Shivraj, gone through your requirement extract and update information from text files. I can help you to create a VBA Automation as per conditions and requirements. Please message me to discuss Thêm

₹1050 INR trong 3 ngày
(0 Nhận xét)
0.0
msalman1262

I have best knowledge and experience regarding these types of work. I will follow rules and regulation accordingly during the job and I will trying to my best as per me.

₹1050 INR trong 4 ngày
(0 Nhận xét)
0.0