Excel 2016 formula to change file source of linked *.txt data

Concluído Postado há 7 anos Pago na entrega
Concluído 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).

Processamento de Dados Processamento de dados Excel

ID do Projeto: #13251573

Sobre o projeto

19 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

satishtl

- Went through the excel file and the two text files. - Based on the text file name that you enter in the data gets populated in the Excel for the formulas to work. - This can be done using VBA. - Have expertise i Mais

$30 USD em 1 dia
(51 Comentários)
6.1

19 freelancers estão ofertando em média $22 nesse trabalho

younus15

Professional with 5+ years experience as a data analyst . Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipula Mais

$15 USD em 1 dia
(150 Comentários)
6.3
vsprybhanu

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

$30 USD em 1 dia
(80 Comentários)
5.6
tanvirmazharul04

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.

$20 USD em 1 dia
(21 Comentários)
3.7
NataliyaKNA

Feel free to hire for: - Data entry - data processing - data scraping - data mining - Web Research - Microsoft Office - Microsoft Excel - PDF Conversion - Copy Typ Mais

$30 USD em 1 dia
(15 Comentários)
3.4
mnazmih1985

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

$15 USD em 1 dia
(11 Comentários)
3.2
ALHAMMAD77

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

$25 USD em 1 dia
(2 Comentários)
2.0
sureshoragadam

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.

$35 USD em 1 dia
(4 Comentários)
2.3
shamimbd3537

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

$10 USD em 1 dia
(2 Comentários)
1.1
Muhib87

Hello, I have more experience with this task. (data entry, copy paste). Please check my profile. i have a team with 5 member. I am very much Familiar with this work. Recently i have done a project like this. I will do Mais

$15 USD em 1 dia
(3 Comentários)
0.6
pradeepreddy1

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

$10 USD em 1 dia
(0 Comentários)
0.0
pranesh5485

Excellent excel skills with experience of excel formulas and other components of excel to provide simple and robust solutions.

$25 USD em 1 dia
(0 Comentários)
0.0
Nalinfdo

A proposal has not yet been provided

$15 USD in 2 dias
(0 Comentários)
0.0