what would be the best way to apply if statements and a few other formulas in a automated way?
To explain a little bit deeper. I am running a windows 2003 server and I have a log file that is captured weekly in csv format. What I would like to do is build a spreadsheet that extracts lines based on a average and if statment in excel (the spreadsheet format is completed). However each week I get a new file and I would like to move that data to excel spreadsheet I have built and replace the old data. This way I could simply have the server email the updated info out weekly amd npt have to spend anytime formating the data into the desired format.
Thanks in advance!