1.

Solve : Excel Script?

Answer»

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!



Discussion

No Comment Found