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

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


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.

Skills: Excel, Excel VBA

About the Client:
( 16 reviews ) JUNAGARH, India

Project ID: #33779188

Awarded to:


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 More

₹600 INR in 1 day
(5 Reviews)

26 freelancers are bidding on average ₹1496 for this job

(182 Reviews)
(108 Reviews)

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 More

₹2550 INR in 1 day
(135 Reviews)
(73 Reviews)

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 More

₹1500 INR in 1 day
(26 Reviews)

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 More

₹1500 INR in 4 days
(15 Reviews)

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 More

₹2000 INR in 5 days
(15 Reviews)

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 in 7 days
(0 Reviews)

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 More

₹1050 INR in 7 days
(0 Reviews)

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 More

₹1000 INR in 7 days
(0 Reviews)

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 in 7 days
(0 Reviews)

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 in 40 days
(0 Reviews)

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 More

₹1050 INR in 7 days
(0 Reviews)

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 More

₹1100 INR in 7 days
(0 Reviews)

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 in 6 days
(0 Reviews)

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

₹1050 INR in 7 days
(0 Reviews)

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 More

₹600 INR in 7 days
(0 Reviews)

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 in 7 days
(0 Reviews)

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 More

₹1050 INR in 3 days
(0 Reviews)

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 in 4 days
(0 Reviews)