+ Reply to Thread
Results 1 to 1 of 1

consolidate data from multiple files/worksheets when data in variable location

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    24

    consolidate data from multiple files/worksheets when data in variable location

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1