I have a set of part descriptions that need to be changed. Each part description corresponds to a part number. See the example below of what it would look like in AutoCAD.
But this list can get really long. Each part number and each description is a seperate text string or mtext string.
I plan on having an excel spreadsheet that has a list of all part numbers that my company uses with their corresponding descriptions.
I would like to use the part number to find the appropriate description and then change the description.
Hopefully this can be done automatically for a list of part numbers and their descriptions.
Is there a way to do this?
i might have picked up the wrong end of the stick, but have you looked at the datalink manager (Tools -> Data Links -> Data Link Manager...)
You can link the excel sheet to the drawing, similar to an xref, so when the excel file changes, you will get a notification bubble down the bottom right
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register