Hi people.
I am trying to set up in Excel a way for the spreadsheet to query a website on our intranet that basically gives a summary of the calls logged at our call centre... number added over the last week, number completed etc.
I know I can get that data by using the spreadsheet as an external data source which works fine but I need it to do something slightly different.
I want the spreadsheet to show this weeks info next to last weeks and so on. This way we can see the long term picture.
e.g.
---------, week 1, week 2, week 3
new jobs , 50 , 40 , 45
completed, 40 , 46 , 30
That sort of thing.
Any help, suggestions, ideas, FAQs are most appreciated.
(i normally program in asp!)
Thanks,
Bevan
I am trying to set up in Excel a way for the spreadsheet to query a website on our intranet that basically gives a summary of the calls logged at our call centre... number added over the last week, number completed etc.
I know I can get that data by using the spreadsheet as an external data source which works fine but I need it to do something slightly different.
I want the spreadsheet to show this weeks info next to last weeks and so on. This way we can see the long term picture.
e.g.
---------, week 1, week 2, week 3
new jobs , 50 , 40 , 45
completed, 40 , 46 , 30
That sort of thing.
Any help, suggestions, ideas, FAQs are most appreciated.
(i normally program in asp!)
Thanks,
Bevan
