Hi all,
I need to assimilate data from multiple sheets into a "master" or "results" sheet. I do medical research and acquire data from multiple sources. Depending on the source, it may be in .xls, .csv, or .txt format but all are easily opened in an appropriate format in Excel and make nice tables that don't need to be reformatted. Each sheet has many different data values that are categorized (in columns) by type, for example, columns may have heart rate, blood pressure, respiratory rate, age, etc and the rows are multiple values for a given experiment. One program places averages for each column at the bottom of the sheet. What I would like to do is gather selected data points from each file and assimilate them into one master worksheet. Right now I am doing it by hand. I know that VLOOKUP can find data in a table format even on different sheets and transfer that data to a different worksheet. Here's what I can't figure out... Each .csv or .txt file would represent a different experiment and I would like to combine them into one sheet (with rows representing each experiment). The individual results files are numbered sequentially.
I attached an example of a data file (in .txt format) that I would want to extract certain data from. In the example file, I want to extract the average Pmax, Pmin, HR (cells I40, J40, O40). For other experiments, saved in other files (i.e. 7462b.txt), I would want to extract the same data values, but they may be in a different row.
Any ideas? Even references to other posts (haven't found exactly what I'm needing). Thanks in advance!
Bookmarks