I found some code on the net and modified it to suit. The original code can be found on http://www.mrexcel.com/forum/showthread.php?t=390072
My code looks up a table from a web page (Username authentications from a Radius server) then copies the table to a separate sheet (sheet2). Then counts the rows (amount of authentications in 24hrs) in the table and adds the result to the column in sheet 1. With this macro I can run through a thousand or more lookup's in less than a couple of minutes.
You may have to modify it to suit
Bookmarks