Using excel for serverlist
 

hey
i have a excel sheet with around 100 serveres

the sheet is posted on our Intranet

i would like to be abel to ping eacth server relative easy with the
push of a button...
and resolv the hostname into the Ipadresse in a new Cell?
any ideas how to do that`?

Hostname | Ipadrss
(known) | (Unknown)