Excel Macro using vb script

L

Lillian

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,sheet6)
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
 
J

Jim Thomlinson

A couple of quick questions...

Is this something that you need to do on a regular basis or is this more of
a one
time thing.

Why Excel. Make these into 2 seperate tables in Access and link them on the
IP.

Why 2 seperate spreadsheets. Copy the sheets into one workbook and just do a
Vlookup to combine the results.

RSVP
 
L

Lillian

Can someone show me how to do the vb script?

Your help always appreciate it.

Lillian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top