Using Excel to draw AutoCAD drawing I will like to know is it possible to use visual basic as an interface where user can enter data using microsoft excel and all the data will be automatically updated in the autoCAD drawing.
Tom,Just so you know, I actually use the autofilter using VBA in some of my automation(ie. Filter, cut paste to a new workbook). If you set your range for your autofilter to a single column of the data, it will only build the dropdown on the top cell of the range, but will filter all the data.activesheet.Range('D2:D32').AutoFilter 1, CriteriaIf you set your filter as this, it will set the drop down in D2, but will filter the data in the entire table.PS: XL97 so things may have changed if you are using a different version. (19 responses) Trying to do something like this If 'Yards' is in column A then copy and paste all the rows to a new book If 'Grass' is in Column A the.(9 responses) I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkb.(7 responses) I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in.(24 responses) I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as.(10 responses) I have a series of columns for orders on my spreadsheet.
![Macro Macro](/uploads/1/2/5/6/125614405/383384529.jpg)
![Autocad Autocad](/uploads/1/2/5/6/125614405/505821585.png)
The furthest left column contains item numbers, the second column contains the quan.The Holy Grail of Excel Tips $12.60.