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

XMLNodes in headers, footers, text boxes error. 0
XMLNodes in headers, footers, text boxes etc. 0
XMLNodes in headers, footers, text boxes etc. 0
XMLNodes in headers, footers, text boxes etc. 0
Using Cell Contents to Reference External Workbooks 2
Loop from left to the right 5
Loop is slow trying array code 17
Copy columns and paste with blank column between 5

Top