Log File to Chart

[bjweber]

I have a log file being placed into excell from lab tests being performed. There are two types of lab tests being performed at differing intervals with an accompaning set of records in a row. I usually sort the data once per month the chart with the adjusted ranges. I would like as the information is placed into the log file to be sorted and place into another file so that I can have a running graph of the charted information. I think I need three worksheets.....one for the log file and the other two for the two types of tests performed and related information. Can this be done? Thank you, Bill