Excel VBA for DATA IMPORT FROM .TXR FILES to excel file
Budget ₹600-1500 INR
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.
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
26 freelancers are bidding on average ₹1496 for this job
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
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
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
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
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.
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
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
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.
I am student i know to do tele calling or excel entry or data entry i am hardworker or smartworker..
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
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.
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
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.