Excel 2016 formula to change file source of linked *.txt data
$10-30 USD
Pago na entrega
I have a laboratory instrument that generates txt files of time and voltages from sensors. I can name the files and place them in specific folders. I have a master excel sheet that converts the voltages into usable data. This is a manual process.
I desire to automate this process by modifying the underlying formula in the master excel sheet. To do this I need to designate the external *.txt file where the data resides. I would like to have one cell in the master excel sheet that holds the name of the external *.txt file and when updated or changed will change the formula of the other cells. This will allow the excel sheet to update automatically and not rely on a manual cut and paste process.
I have looked at several formula approaches: INDIRECT, INDEX and CONCATENATE but can't get the desired result. The target files are in a Tab delimited format and will reside in the same folder as the excel sheet. I have attached an example of the spreadsheet showing the current underlying formula and the desired field to change, in addition to two sample *.txt files with differing names (only one digit changed).
ID do Projeto: #13251573
Sobre o projeto
19 freelancers estão ofertando em média $22 nesse trabalho
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I can do this job using Excel VBA Programming or Advanced Formula. VBA is more flexible than formula. Sometimes formula is not Mais
I am highly interested in your project. If i get your project to do then i will surely use the best way to complete properly. I think i will fully satisfy you by my work.
Feel free to hire for: - Data entry - data processing - data scraping - data mining - Web Research - Microsoft Office - Microsoft Excel - PDF Conversion - Copy Typ Mais
Hello there I hope you're doing well This can be done by VBA & Formulas MIX i did that before many times, i will deliver within hours i gave you the fair price for such a projects lets discuss some more if you Mais
I have completed a bachelor degree in science of electrical engineering. I have strong skills in the field of electrical engineering. Also I can deal with all math, circuit, principle of communication. As Arabic is my Mais
hi, i can do this for you, i have more than 15 years of experience in building office automation tools that helps my client in their day to day activities. looking for your response. regards Suresh.
Hi, I will work as per your direction. I ensure you the accuracy of my work. I am ready to start working right now.I will show you sample to make you sure about the quality of my work. I am waiting for your response to Mais
Hello sir. I am student of BITS-PILANI hyderabad campus. I have a great interest in reading books sir. I love writing , I have written few blogs too. I am an active member of our college journal club too .I am also goo Mais
Excellent excel skills with experience of excel formulas and other components of excel to provide simple and robust solutions.