Hello I need help with a macro. I have written macro's in other
languages but not in excel. I have a workbook on Page two of the
workbook you have the following info:

Zone______View____Name_____Type_____Date
rnc3002___________atn0609___CNAME____wbts1
__________________brk7059__CNAME____wbts10

And on page three I have

Zone_______View___Name____Type______Data
rnc3002___________wbts1_____A________44.1.0.2
__________________wbts10____A________44.1.1.34


What I need to output on page one is

RNC_____Name______Ip address
rnc3002__atn0609______44.1.0.2
rnc3002__brk7059______44.1.1.34




The first two pages are drawn in from a web inquiry, to associate the
site name with the ip address I need to use the wbts name. I have been
playing with this for a while and am getting nowhere. Obviously there
is more than just two entries (around 5000) and to complicate things
some wbts's are missing either the name or ip add, these would still
need to be copied but with a preset value in the appropriate box.

Can Excel help with this or do I need to be looking at Access

Any help would be much appreciated

Phil