CREATE A LEGEND/TABLE DEPENDING ON THE VALUE I WRITE

[Anonymous]

Hello, 

I have an excel chart with information about parcels/plots of land, which are, each of them, differently affected by a wind farm.

I need to prepare one layout per parcel transfering the information I have in excel about the affection to each layout. There are a lot of parcels so it would take too much time to write everything.

I got to link the entire chart with all the parcels to the model, but in the presentation I would only need the information of one only parcel and not all of them. 

If autocad would work like Excel, I guess I would need the command VLOOKUP, so I would only write the number of the parcel (for example 16) and I would get only the information related to that parcel (the higlited one).

In other words I need to filter the information of the chart I have (in excel or linked from the excel but in autocad) so I can get only the info related to the parcel I filtered.

My english is not good enough so if I haven't explain the situation properly please let me know and I'll try again.

Thank you in advance. 

Iris

[zalant]

When you create a data link to an Excel worksheet, you can do the whole sheet or a named range. The named range can be as little as one single cell. Then, you could insert a 1-cell table from that data link, giving you just that one piece of information from the linked Excel file.

Similarly, you could copy the single cell from within Excel, then use Paste Special in AutoCAD to paste in the cell and maintain the link:

Either of the "As:" options will work. Ts pastes in an OLE object, while AutoCAD Entities makes a data link and inserts an AutoCAD table.

[Jowennl]

Hello Mantenimiento,

It seems what you are trying to do is very similar to excel/csv to block attribute or titleblock. I've seen so many cad titleblock or attribute inside cad being update by excel.

Please see attached linked below and see if you can apply that to what you are trying to achieve. Just a suggestion.

Option 1 -  Updating AutoCAD Block Attributes using Microsoft Excel - by The CAD Geek

Option 2 -  updatetitleblock lisp routine - by Lee Mac

This needs you to learn how to create block attribute. But very easy to do. Hope this is a possible alternative approach.

Cheers,

Jowenn