Hi there,

Ive been given a task to extract data. And i guess this is a common task.
Does anyone have any advice on this? It involves the following process..

As this is a weekly task. I need to take the previous sheet and put all the
values
to zero, this is usually done by copy and paste. Then make the graphs point
to this page. Then make sure the date and time colun is in the correct format
as some times it comes in seconds. Sort columns in ascending and descending
accordingly. work out a average for one of the columns. and then in another
master sheet put the min max and average values of the columns. I hope thats
Clear..

It would be great to automate this process if at all possible. Would
appreciate any
tips or answers.

Many Thanks

Island