Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!rice!uw-beaver!ubc-cs!van-bc!rsoft!mindlink!a523 From: a523@mindlink.UUCP (Frank Murray) Newsgroups: comp.sys.ibm.pc Subject: Re: Quesion about Spreadsheets Message-ID: <604@mindlink.UUCP> Date: 18 Oct 89 00:45:47 GMT Organization: MIND LINK! - British Columbia, Canada Lines: 35 > 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]