If your predefined spreadsheet looks like a table (one row per record), then you
could take a look at Data|form. It might be close to what you want--but not
quite.

I'd look at John Walkenbach's Enhanced DataForm
http://j-walk.com/ss/dataform/index.htm

It might be so close....

Dave wrote:

I'm try to figure out how to build an entry form or
series of diaglogue boxes with fields and drop down
selection boxes that when data is entered or selected, it
auto loads a predefined spreadsheet. The method and look
should be something like the program Expensable. Anyone
know how to do this in Excel???

--

Dave Peterson