Hello all!
I have a workbook that has an imported .txt file in each worksheet. Each imported data set is dynamic, but the range I am interested in starts at "B21" for each sheet.
I also have a master tab in the beginning that I would like to use as a summary that would include the scan name, the minimum value, maximum value from each dynamic range.
Scan Name = "A1" from each worksheet
I have attached the file with the data from two imported sets of data. Any help is appreciated. Thank you!
I have a workbook that has an imported .txt file in each worksheet. Each imported data set is dynamic, but the range I am interested in starts at "B21" for each sheet.
I also have a master tab in the beginning that I would like to use as a summary that would include the scan name, the minimum value, maximum value from each dynamic range.
Scan Name = "A1" from each worksheet
I have attached the file with the data from two imported sets of data. Any help is appreciated. Thank you!