Bruce Kieffer Posted March 22, 2021 Share Posted March 22, 2021 Is there some method to create an alphabetical column list of A, B, C, and so on in a worksheet? I did this in my worksheet (screenshot) using records, but that is tedious work. Can anyone suggest a possible simpler solution? Quote Link to comment
Hans-Olav Posted March 22, 2021 Share Posted March 22, 2021 A workaround? create excel file fill down import to VW Copy Paste Quote Link to comment
Bruce Kieffer Posted March 22, 2021 Author Share Posted March 22, 2021 1 hour ago, Hans-Olav said: A workaround? create excel file fill down import to VW Copy Paste OK, but not the solution I want. I can create a separate worksheet in Vectorworks that shows the IDs and then butt it next to the cutting list worksheet, that works too, but again not the solution I want. Quote Link to comment
Bruce Kieffer Posted March 22, 2021 Author Share Posted March 22, 2021 (edited) 3 minutes ago, Pat Stanford said: Select a single cell and copy. Select a bunch of cells and Paste. I don't follow what you are suggesting. Edited March 22, 2021 by Bruce Kieffer Quote Link to comment
Pat Stanford Posted March 22, 2021 Share Posted March 22, 2021 I deleted ti because I did not read your initial post closely enough. The answer to your actual question, which is can I manually enter data into data base rows and have it stay fixed is NO. ALL of the data in a database row MUST be associated with the object specified in that subrow. You could attach a custom record and store the data there, but if you change the sort order of the database the custom record.field will sort with the objects. The question I answered was the one you asked which is there an equivalent to Fill Down. In worksheet rows in VW you can Copy a formula from one cell then select a range of cells and Past and it will act pretty much like Fill Down does in Excel. 1 Quote Link to comment
Bruce Kieffer Posted March 22, 2021 Author Share Posted March 22, 2021 Interestingly I can attach my Part ID record to an object and define the ID and then go into the worksheet and changed the defined ID which changes it in the record ID too. That makes me think maybe I can drag and drop a "blank" or placeholder type record onto the drawing objects, and then type in the IDs into the worksheet. I'm going to play around with that a bit. (I see I need to spell Materials correctly!!!) Quote Link to comment
Pat Stanford Posted March 22, 2021 Share Posted March 22, 2021 Yes that will work, but if you then resort the data, the manually typed in data will still be "stuck" to the object it was attached to, so it will not still be A, B, C, etc. Quote Link to comment
Bruce Kieffer Posted March 22, 2021 Author Share Posted March 22, 2021 (edited) It works, and I understand that it may need to be redone if the sort order is changed, but even so, typing the changes in the worksheet column is infinitely faster than changing each object's record ID. Still not a fill down function, but it's much better than what I was doing. Edited March 22, 2021 by Bruce Kieffer 1 Quote Link to comment
michaelk Posted March 22, 2021 Share Posted March 22, 2021 Hi Bruce! I do something like this all the time. If you keep another worksheet with a column that is A B C … Z You can select a range of those cells, copy, go back to the original worksheet with the database select exactly the same number of cells and paste. If your objects are already in order it makes it very fast. You can also accomplish minor reordering by changing something to C.5, C.6. etc. to get the correct order. Then copy and paste again. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.