with loop

A

Anonymous

I have 2 tables/range on the same worksheet which describe lines. Each line has 2 endpoints (nodes) and a length. Each node has a set of coordinates. The table/range "Coords" consists of NodeNum, XCoord,YCoord.

The Table/Range "Mylines" consists of ID, Node1, Node2, Length.The Node1, Node2 columns contain the line segment begin/end NodeNum from the Coords table.

For Each coordinate pair in the Coords table I need to find any duplicate coordinate pair and NodeNum, delete the row containing the duplicate coords, and change the NodeNum in the Node1, Node2, fields/columns of the MyLines Table. Thus line intersections will share the same NodeNum.
thanks
 
O

OssieMac

Can't understand the description. Can you post an example of the source data
and then an example of what you want it to look like after manipilation.

Also are you looking for a worksheet formula or macro code to do this?
 

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

Similar Threads

Problem with a loop and column references 27
Cluster problems 1
Parsing of App.config varies by machine 1
Selecting range with loop in VBasic 2
Help with loop-I'm stuck 7
Working With A Loop 2
convert long list into shorter list 4
Problem with Select Case construct? 1

Top