Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked/Sorted or Filtered Sheet
We are an engineering firm that frequently links Excel
spreadsheets to AutoCad. When AutoCad opens a drawing file that has an Excel link it automatically checks the Excel file for any updates. The AutoCad drawing stays in sync with the Excel file and it works great! However, we need to do this in a more complex manner: We need to create: a) a Master spreadsheet that contains all information regarding a project and frequently has new rows added, b) various linked spreadsheets that take the data from the Master and sort/filter it based on various criteria (e.g., column A= T or column A=DI), c) link the linked/sorted/filtered spreadhseet to AutoCad. So, the issue becomes this: how can we force the worksheet linked to AutoCad to automatically refresh itself each time it is opened? How can we guarantee that the sort/filter contains all of the latest data? Thank you for your time. This forum is invaluable to us here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorted Linked data doesnt stay together | Excel Discussion (Misc queries) | |||
Can a filtered list (VisibleCellsOnly) be sorted? | Excel Discussion (Misc queries) | |||
Excel data filtered and sorted --- how can i get the workbook to D | Excel Discussion (Misc queries) | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
filtered sorted packing list report from data table | Excel Discussion (Misc queries) |