Hi all,
I currently have a program which monitors vibration events and outputs a csv file (approx 6 meg) every 10 seconds. The monitor will usually run for between 30 and 40 minutes at a time.
The problem is, when I collect the data, I have to search each file individually and look for the one that has the highest vibration reading, which takes me a long time.
Basically I get vibration readings in columns B,C and D, from row 20 to row 200,019. Currently I open each sheet individually, and type =max(b20:B200019) in cell b19, drag that across to column d. I then enter =sum(B19:D19) in cell E19, and use the file with the the highest E19 value.
Is there a way I can run a macro that will look through every sheet in a specified folder, and tell me which worksheet has the highest values?
Any information would be appreciated.
Cheers
John
I currently have a program which monitors vibration events and outputs a csv file (approx 6 meg) every 10 seconds. The monitor will usually run for between 30 and 40 minutes at a time.
The problem is, when I collect the data, I have to search each file individually and look for the one that has the highest vibration reading, which takes me a long time.
Basically I get vibration readings in columns B,C and D, from row 20 to row 200,019. Currently I open each sheet individually, and type =max(b20:B200019) in cell b19, drag that across to column d. I then enter =sum(B19:D19) in cell E19, and use the file with the the highest E19 value.
Is there a way I can run a macro that will look through every sheet in a specified folder, and tell me which worksheet has the highest values?
Any information would be appreciated.
Cheers
John