
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I am generating an Index of Drawings where I have a table set so Columns A, B, and C are set to display specific attributes of a specific Sheetset Layout. I double click the existing data that is in the cell and it brings up the sheetset 'Field" box. I select 'SheetSet' from the Field names menu, I select sheet ES-100 from the Sheet Navigation Tree, and then select SheetTitle from the Property menu. For Column B I repeat the process, but this time I select SheetNumber from the Property menu, and finally, in Column C I repeat the process again and select SheetDiscription. What I get is a table that has this data in Columns a though C: ES-100 | 001 | INDEX AND LEGENDS. I need to do that for about 100 sheets. For the sake of this question, lets call 'SheetTitle' Attribute A, SheetNumber Attribute B, and SheetDiscription Attribute C. Is there a way to set up each cell with what attribute I want it to display but display the data for the sheet that column A is looking at? To put it in Excel speak, The cell A1 is looking at attribute A for layout ES-100. I want Cells B1 and C1 to grab Attribute B and C respectively but using the layout that A1 is grabbing its attribute from. This way i only have to point one cell in each row to the correct sheetset layout and Cells B and C will automatically grab the properties from that layout. This may be a basic question, but I am looking for ways to automate what I am currently doing manually.
Solved! Go to Solution.