foxm@tramp.Colorado.EDU (Mike Fox) (10/18/89)
The problem: A construction company wants to standardize the way they do bids. They will use a spreadsheet program to enter bids. What they are running into is that there are so many catagories that making a large worksheet is not practical. The goal is to make the worksheets quickly and easily. I'm wondering if there is a way to store rows of a worksheet and then insert them into the worksheet. The ideal procedure would be a pop-up window from which the desired items could be selected and inserted into the sheet. Is there a spreadsheet or utility that will do this? ---------- fox_m%cubldr@vaxf.colorado.edu BITNET foxm@tramp.colorado.edu Internet
a523@mindlink.UUCP (Frank Murray) (10/18/89)
> foxm writes: > > Msg-ID: <12890@boulder.Colorado.EDU> > Posted: 17 Oct 89 19:36:58 GMT > > Org. : University of Colorado, Boulder > Person: Mike Fox > > > The problem: A construction company wants to standardize the way they do > bids. They will use a spreadsheet program to enter bids. What they are > running into is that there are so many catagories that making a large > worksheet is not practical. The goal is to make the worksheets quickly and > easily. > I'm wondering if there is a way to store rows of a worksheet and then > insert them into the worksheet. The ideal procedure would be a pop-up > window from which the desired items could be selected and inserted into > the sheet. Is there a spreadsheet or utility that will do this? > > > ---------- > fox_m%cubldr@vaxf.colorado.edu BITNET > foxm@tramp.colorado.edu Internet Humm, sounds like you could write a Lotus 123/VP-Planner macro to save a portion of the spreadsheet to a DIF file, and export the DIF file to DOS. Upon loading the next spreadsheet, you could write a macro to import the DIF file, insert it in the spreadsheet, and recalculate. Hope this helps... Frank Murray MindLink ! [523]