Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! macro needed to join two worksheets, using a coloum on each sheet to pair entries
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Macro Help Needed | Excel Discussion (Misc queries) | |||
join worksheets | Excel Discussion (Misc queries) | |||
Regonise coloum A while adding up coloum B to give a result in C | Excel Discussion (Misc queries) | |||
macro to insert pair of formulae in x number of rows -URGENT!!! | Excel Programming | |||
Macro help required for updating old sheet with new entries | Excel Programming |