I have two excel spreed sheet, one call subnet.xls, it has three fields. it
has about 300 rows, as following:
ColumnA ColumnB ColumnC
Ipaddress, gateway, subnet
192.168.1.100 192.168.1.1 255.255.0.0
--- .101 " "


the other excel spreed sheet is call all.xls, it has 6 different
worksheet(sheet1,sheet2,sheet3,sheet4,sheet5,sheet 6)
ColumnA ColumnB ColumnC ColumnD COlumnE
abc ddd fff xxx 192.168.1.100

I need to know how to write the vb.net, the condition as following:
if subnet.xls of columnA Ip address is equal to all.xls of columnE, then I
need to move gateway, subnet to all.xls after column H.
so the answer will be like this:
A B C D E F G
--- --- --- --- 192.168.1.100 192.168.1.1 255.255.0.0

so it has loop in the all.xls 6 times.

I really aprreciated all your kindness help.

Lillian