Bruce Kieffer Posted August 25, 2021 Share Posted August 25, 2021 Aside form exporting the worksheet to Excel, is there a way to make a shopping list of these items in my worksheet? I want to add a Bought column and a Still Needed column. I tried, but I can't mis the spreadsheet with the existing database, and the worksheet does not recognize the Qty. count in the database for use in a spreadsheet. Quote Link to comment
bcd Posted August 25, 2021 Share Posted August 25, 2021 A bit clumsy to set up but this would work: Make each line item a separate Database and in the Bought column enter the value - and subtract Qty-Bought to calculate Still Needed. Quote Link to comment
Tom W. Posted August 25, 2021 Share Posted August 25, 2021 @Bruce Kieffer I think you are using Record Formats for your worksheet already so could you add 'Bought' + 'Still Needed' fields to your record? Quote Link to comment
Bruce Kieffer Posted August 25, 2021 Author Share Posted August 25, 2021 (edited) Both good ideas, but I can see there is no easy way, so export and do it in Numbers is what I will do. But I will try both suggestions to see how they work. Thanks. Pretty easy in Numbers. Only thing is should something change in my Vectorworks drawing, then I need to remember to update my Numbers file. That's why I would like to do it in Vectorworks. I look forward to worksheet improvments in future. Notice the alternating row colors. I have made a Vectorworks worksheet wish for this. It is really helpful for scanning across a line. Edited August 25, 2021 by Bruce Kieffer 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.