Hi!
I am trying to process some data located in separate excel files (a few hundred). The files consist raw data directly downloaded from a data base in the form of books/files with export and import data during a period of time.
The actual location in the sheet varies between the documents, meaning it needs to be a solution that searches and find the value in the sheet. Ideally I would like to construct a number of loops that:
Finds the correcponding value that matches a row and a column. F.e the match between the row with name "China" and the column "Exported value in Q4 2015" and return the value (or the cell index).
Locate the value or cell index in question and return the value of it, and the correcponding 3 values on the row in question. If the value is located in C4, I would like to find the total value for C4+ D4+E4+ F4.
The end goal is a loop that search through all files and repeats the procedure above.Hi!
I am trying to process some data located in separate excel files (a few hundred). The files consist raw data directly downloaded from a data base in the form of books/files with export and import data during a period of time.
The actual location in the sheet varies between the documents, meaning it needs to be a solution that searches and find the value in the sheet. Ideally I would like to construct a number of loops that:
Finds the correcponding value that matches a row and a column. F.e the match between the row with name "China" and the column "Exported value in Q4 2015" and return the value (or the cell index).
Locate the value or cell index in question and return the value of it, and the correcponding 3 values on the row in question. If the value is located in C4, I would like to find the total value for C4+ D4+E4+ F4.
The end goal is a loop that search through all files and repeats the procedure above. Hi!
I am trying to process some data located in separate excel files (a few hundred). The files consist raw data directly downloaded from a data base in the form of books/files with export and import data during a period of time.
The actual location in the sheet varies between the documents, meaning it needs to be a solution that searches and find the value in the sheet. Ideally I would like to construct a number of loops that:
Finds the correcponding value that matches a row and a column. F.e the match between the row with name "China" and the column "Exported value in Q4 2015" and return the value (or the cell index).
Locate the value or cell index in question and return the value of it, and the correcponding 3 values on the row in question. If the value is located in C4, I would like to find the total value for C4+ D4+E4+ F4.
The end goal is a loop that search through all files and repeats the procedure above. excel, xls, data management, loops, challenge MATLAB Answers — New Questions

​